View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jody[_4_] Jody[_4_] is offline
external usenet poster
 
Posts: 3
Default How can I get into VBA for a custom toolbar - Excel 97

Thanks to both of you for answering. There is definitely
not an add-in for the toolbar.

Also, as Rob mentioned, I checked in the Attach Toolbars
dialog and the name of the toolbar does appear on the left
hand side but it does not appear on the right hand side in
that screen.

The custom toolbar I am trying to modified is tied in with
some VBA code we use. This code is loaded by setting the
alternate start-up location. The systems administrator
said that's all he has to do in order to set up a new
computer, he does nothing specifically to load the toolbar.

Now, I've done the obvious like to go through the code
that the pull-down menus use and search for the name that
Excel shows as the name of the toolbar. It doesn't find
anything. If it isn't getting loaded here, I can't
imagine where it is. I am so frustrated with this!

Is there a command line statement I can use in the
immediate window in order to see the function associated
with a button? I think I've done all the obvious stuff
like search for the name through the code that IS showing
in the VBA editor and checking the Add-Ins.