View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UpGrade UpGrade is offline
external usenet poster
 
Posts: 10
Default Allow users to edit cells but not save the info

On Fri, 10 Apr 2009 09:46:05 -0700, shelly
wrote:

Is it possible to allow users to edit cells and copy/paste/print but not save?



Yes. Instead of protecting the sheet, you make it a read only file.
That way, they can not save changes back against the original filename.
They would, however, be able to perform a save as, and then write back
against the original name via a file manager.

Maybe you can run a macro that inhibits saving. Ask in
"m.p.excel.programming".