Workbook Sercurity
 

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

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

Workbook Sercurity
 

Any solution that you get will depend on macros.

Macros can be disabled.

So there isn't any sure-fire way to do what you want.



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

--

Dave Peterson