Results 1 to 9 of 9

Disable Save/SaveAs in 2007

Threaded View

  1. #8
    Registered User
    Join Date
    10-05-2012
    Location
    'Merica
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Disable Save/SaveAs in 2007

    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>
    Last edited by keen1598; 09-10-2013 at 12:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1