View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kent Prokopy Kent Prokopy is offline
external usenet poster
 
Posts: 39
Default Application Level Events

I need a way to have a sub within my xla to run every time any workbook gets
or losses focus. So if a new workbook is opened or closed, or you just switch
back and forth between two workbooks.