Disable Save/SaveAs in 2007

**ultimastryder** · 06-25-2010, 06:00 PM

Im currently using this code, however theres multiple ways of doing this.

However, it doesn't encompass the Save feature. Just save as. I need both disabled. Either by BeforeSave event or by disabling them from the menu. The latter would be even better.

Please Login or Register  to view this content.

**ultimastryder** · 06-25-2010, 06:20 PM

Actually, I really need to disable both those options just from the menu.

Is that possible? In 2003 i used this:

Please Login or Register  to view this content.

**ultimastryder** · 06-25-2010, 07:22 PM

Anyone??????

**ultimastryder** · 06-25-2010, 08:42 PM

In fact, If i could just find a way to disable the "Save" function/button that would be great.

I don't even care about "SaveAs". lol

**shg** · 06-26-2010, 12:04 AM

Please Login or Register  to view this content.

You need to force people to enable macros for that to work.

**Andy Pope** · 06-26-2010, 06:27 AM

You can disable the buttons in xl2007 by using ribbonx

Please Login or Register  to view this content.

Note that CTRL+S will still work.

**ultimastryder** · 06-28-2010, 11:45 AM

Awesome!! Yay!! Thanks guys.

**keen1598** · 09-10-2013, 10:21 AM

for some reason I have been unable to get this code to work for me.

I have tried everything I can think of in order to add the remove save and save as buttons from visible and enable to my existing code which currently works.

My code places 2 buttons in the Quick Access Toolbar, that each correspond to a macro embedded in the worksheet. One of the macros is a save function, but instead of saving to the active file, it runs a validation code to compare against an existing database for changes. The active file is only a template sheet, which is why I only want to show my "save" button rather than the actual save and save as buttons, in the menu and QAT.

HELP

Please Login or Register  to view this content.

**Fotis1991** · 09-10-2013, 10:26 AM

keen1598 welcome to the forum. Pls take a few minutes to read forum rules, because:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.