Message box before save
 

Is there a way to program a message box to appear if someone tries to save a
file when a certian cells value is zero?

Message box before save
 

Use the beforeSave event. In the event check for the condition that would
warrant showing the message box. In the event, to cancel the save, set

Cancel = True

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Chance224" wrote in message
...
Is there a way to program a message box to appear if someone tries to save
a
file when a certian cells value is zero?