Results 1 to 3 of 3

Thread: How to disable save a copy function in Excel

  1. #1
    Join Date
    Jul 2011
    Posts
    2

    How to disable save a copy function in Excel

    I created a workbook in excel and I have it set up as “read-only” protected and I was able to disable the “save as” function. Is there any way to disable “to save a copy” function so the workbook can not be duplicated or saved with out permission of the administrator? This workbook is viewed by many people but I do not want the users to be able to save a copy as the workbook will not function properly.

  2. #2
    Join Date
    May 2008
    Posts
    979

    Re: How to disable save a copy function in Excel

    If you want to do that then you will have to download the Visual Studio 2008 and after that enter the code given below. I hope this will help you.
    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
    Jul 2011
    Posts
    2

    Re: How to disable save a copy function in Excel

    Ok Thank you for your help.

    I disabled save as for all my workbooks. How to change it back? I went into visual basics and I do not even see where the command is that I entered to disable save as.

Similar Threads

  1. Cut/Copy/Paste function is working very slow in Excel 2007
    By Rounder1 in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 07:02 PM
  2. Replies: 2
    Last Post: 24-02-2012, 06:52 PM
  3. Disable Save and Save as in Excel 07
    By Casperjo in forum Tips & Tweaks
    Replies: 1
    Last Post: 01-07-2011, 03:07 AM
  4. Automatic Save A Backup Copy in MS excel 2007
    By A-Shah in forum Windows Software
    Replies: 6
    Last Post: 14-05-2011, 10:30 PM
  5. Replies: 2
    Last Post: 03-05-2011, 04:35 PM

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,638,703,655.50208 seconds with 17 queries