View Single Post
  #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