Toolbars

[Wheels]

Hello

Hopefully someone can help me out with this problem.

I have created a custom toolbar to open when the spreadsheet is opene
but It always opens over the spreadsheet (floating) rather then bein
anchored where the standard toolbars are.

Is there a simple peice of VBA code to tell it where to anchor itsel
once open?

 

[JE McGimpsey]

One way:

Commandbars("MyBar").Position = msoBarTop

You might also want to look at the Commandbar object's .RowIndex
property.

 

[GregR]

JE, same question but I want to position ("Mybar") on the same row as
the ("Formatting Bar") not in its own seperate row. TIA

Greg