View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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