Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 194
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
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




  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? Markus Obermayer Excel Worksheet Functions 2 January 2nd 07 03:12 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"