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?

--
Wheel
-----------------------------------------------------------------------
Wheels's Profile: http://www.excelforum.com/member.php...fo&userid=2711
View this thread: http://www.excelforum.com/showthread.php?threadid=46625

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??

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

JE McGimpsey Wrote:
One way:

Commandbars("MyBar").Position = msoBarTop



Thanks for this. :

--
Wheel
-----------------------------------------------------------------------
Wheels's Profile: http://www.excelforum.com/member.php...fo&userid=2711
View this thread: http://www.excelforum.com/showthread.php?threadid=46625