Disable Save / Enable Save As

[Gtrtim112]

I'm looking for a macro that will disable users from using the save function but allow them to save as. I have a code that works OK but here's the catch... I use this spreadsheet myself and have to save each day so I don't want to disable myself... lol. I save a MASTER file each day and then SAVE AS a user file that is shared by multiple people. I don't want to have to insert the code I have on the new spreadsheet each day.

Here's my thinking... I'm curious if there's a code that will "disable" the disable code, save my MASTER workbook, then "enable" the enable code. That's a mouthful, right?

I would place a clear box or button on a page that users would not see and accidentally click on. Only I would know where it's at.

If this isn't possible, no biggie... just thought it would be a good idea.

Here's the code that I currently have:

Please Login or Register  to view this content.

[Fluff13]

You could use something like

Please Login or Register  to view this content.

[Gtrtim112]

You could use something like

Please Login or Register  to view this content.

The message box works just fine but how would I go about getting around the normal save function myself? I see you have the username as Fluff (funny!) but is there supposed to be a place to enter that to bypass the setting?

[Gtrtim112]

The message box works just fine but how would I go about getting around the normal save function myself? I see you have the username as Fluff (funny!) but is there supposed to be a place to enter that to bypass the setting?

Actually... nevermind... I get it now. I enter my username! haha

Can I enter multiple usernames in the code?

[Fluff13]

Yup, you can do it like

Please Login or Register  to view this content.

[Gtrtim112]

Yup, you can do it like

Please Login or Register  to view this content.

Very awesome.... thank you!

[Fluff13]

You're welcome & thanks for the feedback