Detect "Save" menu event

R

Robert Crandal

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
 
H

Harald Staff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

before save event 2
Disabling SAVE AS Temporarily 3
Save not triggering Before_Save event 2
Private Sub Workbook_BeforeSave 2
Automatically copy with save? 8
Save All Worksheets as CSV 7
Problems with Workbook Before Save Event 7
Use Workbook BeforeSave Event to Save Copy to Different Location 9

Top