Macro after save event

[Ada01]

is it possible to have a macro to run after save is pushed and/or after worksheet is closed and save is chosen?

thanks

[royUK]

There is no After_Save event, only the Before_Save event of the WorkBook. What exactly do you want to do

[Leith Ross]

Hello Ada01,

Welcome to the Forum!

Yes, if the macro is placed in the Workbook_BeforeClose(Cancel As Boolean) code module in ThisWorkbook.

Sincerely,
Leith Ross

[Ada01]

How do you set that up. I am in the process of learning some of this stuff and when i comes to modules and workbooks, i start to lose my macro.

I just need the set up so i get the macro in the right place

[Leith Ross]

Hello Ada01,

After you have recorded or written your macro, follow these steps...

How to Save a Workbook Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross