[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: Custom Toolbar Docked amidst all other toolbars

Jim Cone

12/11/2006 9:01:00 PM


Use the Position property...
.Position = msoBarTop

And the RowIndex property...
.RowIndex = Application.CommandBars("Formatting").RowIndex

Also, you may have to set the .Left property...
.Left = Application.CommandBars("Formatting").Width
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primiti...




"Spencer Hutton" <SpencerHutton@discussions.microsoft.com> wrote in message
news:3B3BE58B-358D-4F74-944D-0942273FAE47@microsoft.com...
I have an add-in that when the Workbook_Open event occurs, the toolbar is
added to the commandbars collection. conversely it is deleted on exit with a
similar subroutine. when the toolbar loads, it positions itself just below
the bottom most toolbar in the active window. i always have to grab it and
move it up. it is docked, but it just keep placing itself on the next
toolbar row. how can i make it position itself within all of the other
toolbars each time in the same place. there is room for it to fit.