Force CommandBar Position

[Matthew Pfluger]

I maintain an add-in on my employer's shared drive. Currently, when users
who have installed my add-in launch Excel, the add-in deletes its toolbar and
rebuilds it to ensure they are alway using the most recent version.

However, the code is not remembering the previous location of the toolbar.
It is simply forcing it to msoBarTop. I tried to read, store, and set the
..Top and .Left properties of the toolbar; however, my toolbar cannot dock
itself onto the same bar as other toolbars using this method. Is there a way
around this?

Thanks,
Matthew Pfluger

 

[Jim Cone]

RowIndex is what you want and is used something like this...
MyBar.RowIndex = Application.CommandBars("Formatting").RowIndex
MyBar.Left = Application.CommandBars("Formatting").Width
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Matthew Pfluger"
<[email protected]>
wrote in message
I maintain an add-in on my employer's shared drive. Currently, when users
who have installed my add-in launch Excel, the add-in deletes its toolbar and
rebuilds it to ensure they are alway using the most recent version.
However, the code is not remembering the previous location of the toolbar.
It is simply forcing it to msoBarTop. I tried to read, store, and set the
..Top and .Left properties of the toolbar; however, my toolbar cannot dock
itself onto the same bar as other toolbars using this method. Is there a way
around this?
Thanks,
Matthew Pfluger

 

[Matthew Pfluger]

Perfect. Thanks for your help.
Matthew Pfluger