Excel 2000 VBA - creating new Command Bar

[ABH29]

Hi,

I am trying to create a new Command Bar object using VBA in Excel 2000. I use the following line of code:

Set myToolBar = CommandBars.Add("Custom",msoBarTop)

When I run the code I get a runtime 5 - invalid procedure call or argument error. Would appreciate any help that anyone has in overcoming this problem.

Thanks
ABH

 

[LSTAN]

Hi ABH29

Under what circumstances you got the run-time error.
When you run the procedure the first time?
Or with subsequence running?

by the way, it's works fine in my machine, running Excel2000.

regards
LSTAN