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
<mso:customUI xmlns:doc="http://schemas.microsoft.com/office/2006/01/customui/currentDocument" xmlns:mso="http://schemas.microsoft.com/office/2006/01/customui">
<mso:qat>
<mso:documentControls>
<mso:button idQ="doc:thisworkbook.starterform_1" visible="true" label="ThisWorkbook.starterform" onAction="thisworkbook.starterform" imageMso="HappyFace"/>
<mso:button idQ="doc:ThisWorkbook.Saver_1" visible="true" label="ThisWorkbook.Saver" onAction="ThisWorkbook.Saver" imageMso="SourceControlCheckIn"/>
<mso:button idQ="doc:ThisWorkbook.Saver_1" visible="true" label="ThisWorkbook.Saver" onAction="ThisWorkbook.Saver" imageMso="SourceControlCheckIn"/>
<mso:button idQ="FileSave" visible="false" enabled="false"/>
</mso:documentControls>
</mso:qat>
</mso:ribbon>
</mso:customUI>
Bookmarks