Revisit "Close without Saving Changes", please?
 

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

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

Revisit "Close without Saving Changes", please?
 

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




Ed wrote:

Thanks for responding, Mark. I appreciate the time the MVPs give here.

I tried Read Only once before, and even posted here about difficulties I was
having using it. When I did so, the file would not open as full screen, and
behaved strangely on a few different machines (no explanation was ever
found, but we have various combinations of Excel and operating system
versions floating around).

I am limited in my knowlege of how to work with Excel - like a musician who
can play one solo very well, but can't read music. What I'm trying to do is
create a sheet along the line of Norman Harkin's Excel Functions List -
opening on one sheet as a "title page" with various instructions, etc., and
a button that will then take the user into the data portion. I would like
the workbook to return to the "title page" with all the data intact after
whatever manipulations whenever it's closed, so the next user has all the
data and has to get past the "title page".

I'm aware that code is not all that difficult to crack to get past anything
I set up - especially what a novice like me could do, but I have far more
users who know how to turn off Read Only from the properties than know how
to access the code and get around it.

From the number of posts on the NG about Excel and security, I know this has
been dealt with ad nauseum. So I'm not trying to buck the professionals. I
may just have an idea in my head and not enough experience to know a better
way. Any and all help is appreciated.

Ed

"Mark D" wrote in message
...
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





--

Dave Peterson