Remove Save/Save As buttons from Excel 2007

[keen1598]

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.

[keen1598]

Code Tags added

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.

[HaHoBe]

Hi, keen1598,

donīt you miss the second line at the top of your code? All other controls are neatly opened and closed in the correct way for my eyes.

Please Login or Register  to view this content.

Ciao,
Holger

[keen1598]

Sorry Holger,

I think I copied some code that I had been messing with to see if it worked. This is my current working code. The fact still remains I cannot seems to get the Save/Save As buttons set to disabled.

Please Login or Register  to view this content.