View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Workbook Sercurity

Several questions.

To prevent save set the workbook to read only in windows explorer.
To prevent save as paste this code into the before save event.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = True Then Cancel = True
End Sub

Cut copy paste etc is much more difficult but have a look at hte file below

http://www.savefile.com/files/495953



"mcphc" wrote:

Is it possible to allow a user to open a file and allow them to modify or
delete any data, formats etc but not allow the user to save the file as
anything and also not allow the user to copy any of the data to another
application ie disable Ctrl+C. I know that protecting the workbook and
prevent a user from moving and copying entire worksheets to other excel files
is possible but I need to also prevent copy and paste as well as saving the
excel file.

Thanks