One way:

Commandbars("MyBar").Position = msoBarTop

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

In article ,
Wheels wrote:

Hello

Hopefully someone can help me out with this problem.

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

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