View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Baapi Baapi is offline
external usenet poster
 
Posts: 33
Default Worksheet close event

what is the event that I have to use if I need my macro's to run whenever I
open/close my workbook?

I've used "Auto_Open and Auto_Close". but, problem with this seems to be
that the open macro runs when I open the workbook but, the close macro runs
only when I close all the workbooks (or the Excel application)

how are these handled?
--
Baapi