VBA Code to kick off macro when workbook command to close is initi

[zulfer7]

I wanted some code to run whenever someone was to close the worksheet. Any
Ideas?

 

[Loomah]

Hi
Put your code in the Workbook_BeforeClose event proceedure.

Open the VBE (ALT+F11)
Double click ThisWorkbook in the project explorer window on the left hand
pane
from the left hand dropdown in the code pane (on the right of the window)
choose workbook
Select BeforeClose from the dropdown to the left

;-)

 

[zulfer7]

This was PERFECT!!! Thanks!!!

Hi
Put your code in the Workbook_BeforeClose event proceedure.

Open the VBE (ALT+F11)
Double click ThisWorkbook in the project explorer window on the left hand
pane
from the left hand dropdown in the code pane (on the right of the window)
choose workbook
Select BeforeClose from the dropdown to the left

;-)