Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Code to kick off macro when workbook command to close is initi
I wanted some code to run whenever someone was to close the worksheet. Any
Ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Code to kick off macro when workbook command to close is initi
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" wrote in message ... I wanted some code to run whenever someone was to close the worksheet. Any Ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Code to kick off macro when workbook command to close is i
This was PERFECT!!! Thanks!!!
"Loomah" wrote: 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" wrote in message ... I wanted some code to run whenever someone was to close the worksheet. Any Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Errors in VB Code since adding macro | Excel Discussion (Misc queries) | |||
Macro or OLE method to insert worksheet from template workbook | Excel Discussion (Misc queries) | |||
Runing a macro in a workbook from another macro in other workbook | Excel Discussion (Misc queries) | |||
How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |