I have only the Standard Excel toolbar open. I have created a custom
toolbar which is attached to the file. The custom toolbar is loaded when
the file is opened and deleted when the file is closed. Problem is, my
custom toolbar keeps showing up above the Standard toolbar, and I want it to
be below the Standard toolbar. One PC shows it in the correct vertical
position (below the other toolbars at the top of the page), and the other PC
shows it in the wrong vertical position (above the Standard toolbar). Help!
Both are Excel XP. TIA, James

The RowIndex property is what you are looking for...
MyCustomToolbar.RowIndex = Application.CommandBars("Formatting").RowIndex
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Zone"
wrote in message
I have only the Standard Excel toolbar open. I have created a custom
toolbar which is attached to the file. The custom toolbar is loaded when
the file is opened and deleted when the file is closed. Problem is, my
custom toolbar keeps showing up above the Standard toolbar, and I want it to
be below the Standard toolbar. One PC shows it in the correct vertical
position (below the other toolbars at the top of the page), and the other PC
shows it in the wrong vertical position (above the Standard toolbar). Help!
Both are Excel XP. TIA, James

I would think you need to set it's position property. Perhaps using the
index of the commandbars collection. Do a commandbars.count and assign your
TB the next index number. At least it would always be at the end of however
many TBs there are.

Mike F
"Zone" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have only the Standard Excel toolbar open. I have created a custom
>toolbar which is attached to the file. The custom toolbar is loaded when
>the file is opened and deleted when the file is closed. Problem is, my
>custom toolbar keeps showing up above the Standard toolbar, and I want it
>to be below the Standard toolbar. One PC shows it in the correct vertical
>position (below the other toolbars at the top of the page), and the other
>PC shows it in the wrong vertical position (above the Standard toolbar).
>Help! Both are Excel XP. TIA, James
>

Thank you, Mike and Jim. I'll give that a shot. James
"Mike Fogleman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I would think you need to set it's position property. Perhaps using the
>index of the commandbars collection. Do a commandbars.count and assign your
>TB the next index number. At least it would always be at the end of however
>many TBs there are.
>
> Mike F
> "Zone" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have only the Standard Excel toolbar open. I have created a custom
>>toolbar which is attached to the file. The custom toolbar is loaded when
>>the file is opened and deleted when the file is closed. Problem is, my
>>custom toolbar keeps showing up above the Standard toolbar, and I want it
>>to be below the Standard toolbar. One PC shows it in the correct vertical
>>position (below the other toolbars at the top of the page), and the other
>>PC shows it in the wrong vertical position (above the Standard toolbar).
>>Help! Both are Excel XP. TIA, James
>>
>
>