View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Add-In Toolbar Control - Removing The Toolbar Question


Pat,
Put your code to create the toolbar in the... Private Sub Workbook_AddinInstall() sub.
Put the code to delete the toolbar in the... Private Sub Workbook_AddinUninstall() sub.
Both are event subs in the ThisWorkbook module.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Dreiding"
wrote in message
I'm working on an Excel Add-In that has a custom toolbar. When it's not an
Add-In the toolbar is defined when I open the file (part of workbook_open)
and is removed (before workbook close). I save it as an Add-In. When I open
excel and enabler my Add-In the toobar is displayed. This is just what I
want and expected. My question to you is: What am I doing wrong such that
when I uncheck the Add-in the toolbar remains until I exit and reenter Excel.

What do I need to do to to have the Add-In toolbar removed when unselecting
it from the Add-In dialog?
TIA,
- Pat