Hi,

I build a file in which the user starts with a Macro that hides All Toolbars, and disabled the possibility to close the file with the red X.
The user has to use a Macro to close the file.

This Macro re-installs the Toolbars, enables the Red X. Returns to the start-up sheet, Saves the file and Closes it.

This works perfectly, but the file has to be protected with a Password to Modify as only a few persons are allowed to make changes.

The problem is that other users are allowed to open the file as a "read only" file, and now I have a conflict if these users want to close the file with the Macro. As it cannot save it.

I can of course cut the Macro in two where one macro Saves the File and the other does all the other actions, but I was hoping that someone can help me with a code that leaves the functionality of the existing Macro as it is, but will recognize that it is dealing with a read only version so it will avoid the save part. (or something like that)

Thanks in advance for your assistance.
Kind regards
Rough