Thread: Message Box if Attempting to Save over Master
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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/



Reply With QuoteReply With Quote