Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect "Save" menu event
How can I handle when the "Save" menu option is
selected by a user?? I basically want to run some code either before or after a workbook save occurs. Does this mean that I should handle Workbook_BeforeSave()??? If the "SaveAsUI" parameter is false, does that mean that a "save" occurred instead of a "save as"?? thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect "Save" menu event
Hi
Yes, that is the event you want. And your assumption is correct. Note that if the file is previously unsaved, Save will also display the SaveAs dialog. HTH. Best wishes Harald "Robert Crandal" wrote in message ... How can I handle when the "Save" menu option is selected by a user?? I basically want to run some code either before or after a workbook save occurs. Does this mean that I should handle Workbook_BeforeSave()??? If the "SaveAsUI" parameter is false, does that mean that a "save" occurred instead of a "save as"?? thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate "Cancel" Button on Save/Close Event | Excel Programming | |||
"Save As" Causing a combobox change event to trigger? | Excel Programming | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
How to detect "F2 key" event | Excel Programming | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming |