VBA custom toolbar
 

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

VBA custom toolbar
 

Google is your friend
http://www.google.com/search?sourcei...stom+toolba r

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

VBA custom toolbar
 

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.
--
HTH...

Jim Thomlinson


"donwb" wrote:

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


.

VBA custom toolbar
 

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

"Jim Thomlinson" wrote in message
...
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.
--
HTH...

Jim Thomlinson


"donwb" wrote:

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


.