Thread: VBA Code to kick off macro when workbook command to close is initi
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
zulfer7
 
Posts: n/a
Default 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 With QuoteReply With Quote