Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt to Save Message | Excel Discussion (Misc queries) | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
save as error message | Excel Programming | |||
Eliminating save message | Excel Programming | |||
How to save file without the save message? | Excel Programming |