View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default How can I get into VBA for a custom toolbar - Excel 97

Hi Jody,

Are you sure there isn't a hidden workbook being opened that might have
this toolbar attached to it? Check the alternate startup file location. Any
file that exists there will be opened automatically when Excel starts up.
Toolbars can't appear out of thin air, so it's either being constructed in
code or it's been prefabricated and attached to a workbook that's being
opened. If you want to know the name of the procedure that a toolbar button
is assigned to, choose View/Toolbars/Customize from the menu, then
right-click over the toolbar button and select Assign Macro. The name of the
Macro that appears in the Macro name box of the Assign Macros dialog is the
one being run when that button is clicked.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Jody" wrote in message
...
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.