Using Workbook_AddinInstall -vs- Workbook_Open Events
I always use the Install and uninstall to add items such as menu items, ...
The advantage to using install uninstall is that the menu bar persists even
if the user chooses to cancel after selecting to close Excel. Note with the
Essbase tolbar, if you choose cancel after selecting to shut down Excel the
addin is gone. I use the Open event to create objects and such becuase I need
to instatiate the objects when Excel is opened.Just my two cents but It works
well for me.
--
HTH...
Jim Thomlinson
"Bill Schanks" wrote:
When I create add-ins that have toolbars I always add the custom
toolbars at that time, and remove them in the Workbook_AddinUninstall
event.
I notice that most other addins (EssBase, MS Add-ins) don't do it this
way. The toolbars get added each time the add-in is loaded via the
Workbook_Open event.
Is there some type of common practice that should be used?
Is there some reason why you should choose one over the other? It seems
to me that by using the Workbook_open event it takes longer to load
Excel.
|