Message Box if Attempting to Save over Master
 

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.


---
Message posted from http://www.ExcelForum.com/

Message Box if Attempting to Save over Master
 

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

--
Regards,
Tom Ogilvy

"sowetoddid " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

Message Box if Attempting to Save over Master
 

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

--
Message posted from http://www.ExcelForum.com