Toolbars

  • Thread starter Thread starter Wheels
  • Start date Start date
W

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?
 
One way:

Commandbars("MyBar").Position = msoBarTop

You might also want to look at the Commandbar object's .RowIndex
property.
 
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
 
Back
Top