View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default trouble getting addin's workbook_open procedure to recognize activeworkbook

A more robust approach would be to keep the add-in installed, use
Workbook_Open and Workbook_BeforeClose to create and destroy your menu, and
use application events such as App_WorkbookOpen, App_WorkbookActivate,
App_SheetActivate to turn on (enable) your menus, and
App_WorkbookBeforeClose, App_WorkbookDeactivate, App_SheetDeactivate to turn
off (disable) the menus.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"martin" wrote in message
oups.com...
It's a real add-in. I created a new, blank workbook, selected File/Save
as.., typed "Test" in the file name box and selected the last file type
from the list. It's in c:\documents and settings\...\microsoft\addins\.