Replies

Thanks Hans,

I haven’t tried it yet, but it gets me going in the right direction.

Mike

I tried it and it works, although I modified it to fit my purpose. The shortcut properties do change, however, like you say, the shortcut is still there.

A great tool would be a “windows script recorder”, similar to the macro recorder in Excel, that could record scripts across the Office applications and/or within the Windows environment.

Thanks Jefferson,
Michael Read

Thanks Jefferson, I think!

Boggles my marbles at first, but I think I get the drift.

Thanks for your time,
Michael Read

Thanks for the reply Legare,

In my workbook, the Application.Visible=False is in the first part of the Close event. In other words, the workbook needs to be closed because of various things such as creating text files and other actions which occur as part of the close event. I just want to prevent them from attempting to reopen it until the code in the Close event is complete and the workbook is actually closed.

Sorry, I should have been more specific in my original post!

Thanks,
Mike

Thanks!