Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you make it so the person must "save as"
I created a custom quote worksheet with a lot of lookups, validated tables
and functions. Even though I named the worksheet "ORDER FORM - Open and SAVE AS or I'll cut your fingers off", people still get in and overwrite my formulas and save instead of save as. The problem is, sometimes they do need to overwrite, but I need to have the worksheet stay intact when they exit. Can you force a worksheet to exit without saving changes, or force a "save as"? I do have a backup copy hidden that I can always go to, but I'd like to force the stupid people in my office to save as. Thanks, Susan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you make it so the person must "save as"
Save your file with a write-password, read-only recommended. (In the Save As
dialog, use Tools, General Options). Then your users can accept the read-only recommendation when they open the file, and they'll get a warning if they try a simple save. --Bruce "Bernina27" wrote: I created a custom quote worksheet with a lot of lookups, validated tables and functions. Even though I named the worksheet "ORDER FORM - Open and SAVE AS or I'll cut your fingers off", people still get in and overwrite my formulas and save instead of save as. The problem is, sometimes they do need to overwrite, but I need to have the worksheet stay intact when they exit. Can you force a worksheet to exit without saving changes, or force a "save as"? I do have a backup copy hidden that I can always go to, but I'd like to force the stupid people in my office to save as. Thanks, Susan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you make it so the person must "save as"
You should rename your model Worbook as someting.xlt
That will solve your problem HTH -- AP "Bernina27" a écrit dans le message de ... I created a custom quote worksheet with a lot of lookups, validated tables and functions. Even though I named the worksheet "ORDER FORM - Open and SAVE AS or I'll cut your fingers off", people still get in and overwrite my formulas and save instead of save as. The problem is, sometimes they do need to overwrite, but I need to have the worksheet stay intact when they exit. Can you force a worksheet to exit without saving changes, or force a "save as"? I do have a backup copy hidden that I can always go to, but I'd like to force the stupid people in my office to save as. Thanks, Susan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you make it so the person must "save as"
When you save the file, you get a Save As window appear, at the top, there is an option called tools, select this and select General Options, here you get a window with 4 options:- Always create backup - self explanatory Password to Open - self explantory Password to modify - enter here and the only way they can overwrite your existing file is with a password. It will pop up a message on file open, to ask either the password to be entered, or open it as read-only. If it is open as read only, when the user saves the file, it will force you to save with another name and without the read-only attribute Read-only recommended - This sounds like what you want, however this pops up a similar message as above, however the user can override, which they probably will (sods law and all that) The other easy option, although not foolproof is to go to the properties of the file in Windows Explorer and mark it as read only, but as you can see if you can do that, so can your user (ie turn off the read-only access). Setting a password is the only reasonable solution, although not entirely foolproof, there are crackers out there who will remove readonly passwords! -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=522261 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
How to make this plot? | Charts and Charting in Excel |