Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bernina27
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown
 
Posts: n/a
Default 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
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
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
How do I make each row add up seperatly? Please make it easy... Homeade baker and candy maker New Users to Excel 1 October 23rd 05 09:52 PM
how do I make make my hyperlinks show the email address they are . Dustin Excel Discussion (Misc queries) 0 January 13th 05 02:39 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM
How to make this plot? springwinterfall Charts and Charting in Excel 2 December 22nd 04 08:35 PM


All times are GMT +1. The time now is 02:05 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"