G
Guest
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
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