Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Custom Toolbar Docked amidst all other toolbars


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/primitivesoftware




"Spencer Hutton" wrote in message
...
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default toolbars and toolbar buttons seen instead of customization MIKE MEDLIN Excel Discussion (Misc queries) 0 January 12th 05 11:59 PM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM
Icons on toolbar buttons (Was: Toolbars with macros) Phil Bewig Excel Programming 1 February 2nd 04 03:49 PM
Custom ToolBars Julian[_3_] Excel Programming 1 January 8th 04 06:22 PM
saving toolbar buttons on custom toolbar Paul James Excel Programming 12 August 6th 03 08:28 AM


All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"