After serious thinking Thomas Jambrich wrote :
I have the same problem. I looked at the answer but it doesn't seem to help
me. I created my macros in Excel 2003. One of the macros is in
"ThisWorkbook" under 'Microsoft Excel Objects' and it created a ?toolbar?
(say MyToolbar) when the workbook was opened under Excel 2003. It contains
a list of various macros that I could click on to execute various functions
in the workbook. The others are under either in the ?Modules? or ?Forms?.
The macros that are under the ?Modules? or ?Forms? seem to run when I click
on them in the Visual Basic code form, but the macro in the 'ThisWorkbook"
does not, i.e. it doesn't insert my toolbar nor does it open MyToolbar when I
open the workbook. Can anyone help me please?

Please post your code so we can better help you based on that rather
than guessing all over the place!

One thing I know for sure is that you can't have code in both
Workbook_Open AND Auto_Open(). It has to be one or the other. Also,
Auto_Open MUST be placed in a standard module under the Modules section
of a project.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc