View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Mark D[_4_] Mark D[_4_] is offline
external usenet poster
 
Posts: 3
Default Revisit "Close without Saving Changes", please?

er - why not make it read only access then ?

It is possible to disable both the Save & Save As menu items but the user
can reenable them by loading your spreadsheet a second time, and then
closing it.


"Ed" wrote in message
...
I know this has ben dealt with several times on the NG, and I've spent all
morning sifting through what I can find (thanks, Ron de Bruin, for your
excellent Google search tool!), but I'm either not asking the right
questions or not understanding what I'm seeing.

I have a workbook on a company-wide server. I'd like to let the users

open
it, view it, sort, filter, and mangle it at their pleasure, *BUT* close
without saving any changes that have been made. I guess that means the

SAVE
and SAVE AS commands also have to be disabled.

If anyone can help me with this, or point me to the previous discussions,

I
would greatly appreciate it.

Thank you.
Ed