Nokia C3: How to disable save a copy function in Excel

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.
Reply With Quote
#2
Old 12-07-2011
Gunilla's Avatar
Gunilla Gunilla is offline
Member

Join Date: May 2008
Posts: 982
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

Reply With Quote
#3
Old 18-07-2011
kelbel7795 kelbel7795 is offline
Member

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.
Reply With Quote