Message Box if Attempting to Save over Master

S

sowetoddid

Anyone know a code that will evaluate the filename before saving and
generate a message box?

If the filename says "master" and a person clicks save or does a save
as "Master", then it will bring up a message box, prompting users that
they are attempting to save over the Master.


Thanks.
 
T

Tom Ogilvy

Use the beforeSave event to test the name of the workbook. Setting Cancel =
True will cancel the save.
 
S

sowetoddid

The reason why I prefer a message box is because I would the message t
inform the user that they must press ctrl s to save. A different cod
has been linked to "ctrl s" and will save the file with the value
inputted in two of the cells.


Any ideas how to do it that way? What would be the actual code if
did it the way suggested above?


Thanks
 
Top