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".
|