Revisit "Close without Saving Changes", please?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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
 
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.
 
What kind of read-only flag did you try?

Did you use Excel's File|SaveAs|Tools|General Options (xl2002)
<file|saveas|Options in earlier versions???)

Or did you use the windows setting (windows explorer|rightclick on the filename
and choose properties, then readonly)?

If you tried only one, try the other one to see if it works (might be the
simplest solution if it does).
 
Back
Top