Results 1 to 3 of 3

Thread: How do you disable Save and Save As in MS Excel 2007

  1. #1
    Join Date
    May 2011
    Posts
    7

    How do you disable Save and Save As in MS Excel 2007

    Does anyone know the code for turning off "save" and "save as" functions for MS Excel 2007 so one cannot use those functions in drop down menu, shortcut keys and on the Ribbon?

    Thanks,
    Scott

  2. #2
    Join Date
    Dec 2007
    Posts
    1,736

    Re: How do you disable Save and Save As in MS Excel 2007

    For that you will have to download Visual Studio 2008 and enter the code that is given below:

    Code:
    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    MsgBox "The 'Save As' function has been disabled."
    Cancel = True
    End Sub

  3. #3
    Join Date
    May 2011
    Posts
    7

    Re: How do you disable Save and Save As in MS Excel 2007

    It's working. Thanks. Now, I was wondering, how do you disable cut, copy and paste functions. I have found a way to do it for shortcuts, drop down menus, pop up menus, but not disable it from the ribbon. Can you help me on this?

    Thanks,
    Scott

Similar Threads

  1. Replies: 3
    Last Post: 04-03-2012, 01:53 AM
  2. How to disable save a copy function in Excel
    By kelbel7795 in forum Windows Software
    Replies: 2
    Last Post: 18-07-2011, 09:17 PM
  3. Disable Save and Save as in Excel 07
    By Casperjo in forum Tips & Tweaks
    Replies: 1
    Last Post: 01-07-2011, 03:37 AM
  4. Error Message while trying to Save a file in Excel 2007
    By hatred in forum Windows Software
    Replies: 5
    Last Post: 26-03-2010, 04:00 AM
  5. Replies: 10
    Last Post: 17-11-2007, 02:21 AM

Tags for this Thread

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
  •  
Page generated in 1,711,670,907.39955 seconds with 17 queries