View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default How can I get into VBA for a custom toolbar - Excel 97

So there is a file loading from the Alternate Startup File Location that
creates the toolbar? Is it an add-in (XLA)? The only way you can see if it
has toolbars attached is by making it the active workbook in Excel and then
go into Attach Toolbars. If it is an add-in you cannot make it active. So
click on the add-in's ThisWorkbook node in the VBE's Projects window and
press F4 to open the Properties window. Change the IsAddin property to
False.

The toolbar may not be attached but instead create by code at startup.
Search the VB project for "Commandbars" or "Menubars" for this code.

--
Jim Rech
Excel MVP