View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Access101 Access101 is offline
external usenet poster
 
Posts: 35
Default Docking a Toolbar and having it stay

Dave, all of this works great. However, is there a way to dock it to the
right of another toolbar, which itself only takes up half the line, and this
way, it would take up the other half of the row?

If I dock it at Top, the rows are Menus, Standard, Formatting, MyToolbar

If I use Left/Top coordinates and free floating, I can get it to the right
of Standard.

And if I manually move the toolbar and close XL, it's back to its fourth row
position again when I open up XL.

Any help is appreciated.

"Dave Peterson" wrote:

With Application.CommandBars.Add
.Name = ToolBarName
.Left = 200
.Top = 200
.Protection = msoBarNoProtection
.Visible = True
.Position = msoBarFloating


You can change this portion:
.Position = msoBarFloating
to
.Position = msoBarTop
or
.Position = msoBarBottom



Access101 wrote:

I've created a wonderful custom toolbar and ADd-in using the instructions at
this web site in XL 2003: http://www.contextures.com/xlToolbar02.html

However, the custom toolbar always free floats, even if I drag it up and
dock it, save the XLA, save the code window, save my soul.

Any way to get it to stay put so when I open xl again, it's up at the top
with the other toolbars?


--

Dave Peterson