Toolbar position

S

Spencer

I have a custom toolbar created when a worksheet is opened, however I want to
place it next to another toolbar everytime it is opened. I have used the
following code:

MyBar.RowIndex = Application.CommandBars("OtherBar").RowIndex
MyBar.Left = Application.CommandBars("OtherBar").Left

This would work except that at my work we have another toolbar that is
created anytime excel is opened and that is the toolbar I want it next to and
the code for my bar is running first so I get an error.

How do I make it so my toolbar isn't created until the other toolbar has
been created?
 
J

Jim Rech

Perhaps you could delay your commandbar creating sub. Instead of calling it
directly in your Auto_Open or Workbook_Open sub:

AddMyCmdbar

you could call it like this:

Application.OnTime DateAdd("s", 3, Now), "AddMyCmdbar"

--
Jim
|I have a custom toolbar created when a worksheet is opened, however I want
to
| place it next to another toolbar everytime it is opened. I have used the
| following code:
|
| MyBar.RowIndex = Application.CommandBars("OtherBar").RowIndex
| MyBar.Left = Application.CommandBars("OtherBar").Left
|
| This would work except that at my work we have another toolbar that is
| created anytime excel is opened and that is the toolbar I want it next to
and
| the code for my bar is running first so I get an error.
|
| How do I make it so my toolbar isn't created until the other toolbar has
| been created?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top