Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |