Not Save "Read Only" file via Macro

**Rough** · 12-30-2008, 08:09 AM

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

**JBeaucaire** · 12-30-2008, 12:15 PM

If you don't want to change your original macro, nor post anything here for us to look at, an additional macro would be needed, yes?

Create a macro for those users that get to enter a password and make changes. The macro asks for their password, if it is correct, then it unprotects the sheet AND reenables saving capability, perhaps through another macro button onscreen if you wish.