View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lasse[_2_] Lasse[_2_] is offline
external usenet poster
 
Posts: 15
Default Run macro before closing Excel 2007

Hi

I can read a lot of posts regarding Workbook_BeforeClose but can't quit find
the answer to problem.
When using Workbook_BeforeClose it's run when closing the active worksheet
and leaves Excel running without any open worksheets. I need a macro that
runs when the user closes Excel not just the worksheet.
I run a macro that installs a add-in through Workbook_Open and I want to
remove the add-in when the user closes Excel?

/Lasse