VBA custom toolbar

[donwb]

Excel 2003
Can anyone tell me where to find the file containing a custom toolbar
created in the VBA editor.
donwb

 

[Don Guillett]

Google is your friend
http://www.google.com/search?source...rlz=1T4GFRD_en___US219&q=excel:custom+toolbar

 

[Jim Thomlinson]

What project did you do the modifications in. When you open the VBE you
should see the project explorer on the left hand side. If not then Select
View | Project Explorer. The VBE code must have been written in a project.
That project could be your personal workbook, a standard workbook or an
addin. Depending on what the project was will tell you where the code resides.

There is a .xlb file on your computer that stores customizations to your
toolbars but I don't think that is what you are looking for.

 

[donwb]

Hi Jim
I've partially solved the problem.
The toobar to which I referred is the "standard" toolbar which appears
at the top of the VBA compiler page below the Menu Bar and is
therefore not attached to any particular workbook.
I forgot I had edited it a long time ago and mistakenly assumed I had
created it as a Custom Bar.
So presumably that toolbar resides in the *.xlb file along with
any others created for use on the Worksheet.
Many thanks for the response.
donwb