It's already password protected. I was on vacation, she was filling in for
me and on the second or third day she forgot to save the master as a new
workbook for that particular day until she was practically done with the
process. I was hoping for a message of some kind to pop up before she got
very far without creating a new workbook. Thanks anyway.

"JMB" wrote:

File/Save As/Tools/General Options - put in a password to modify. Without a
password the orginal file will be read only and the open file will have to be
saved as a copy using Save As. I believe excel removes the password on the
copy, so another user could open that file (the copy) and make changes, but
your original should remain intact.



"TammyS" wrote:

I have a master workbook that I SAVE AS each day as a new workbook. The
person who fills in for me didn't create a new workbook and made a big
mess--I'm still finding formulas and cells that were changed. I formatted
the date cell to be bright pink if it remains empty, but I would like a "SAVE
AS" message to appear if anything has been typed in cell R110, R119, R128, or
R137. The date cell is S163. I have tried various formulas but got error
messages or not the result I wanted. I would appreciate any help or a better
suggestion to deal with problem. Thanks.