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

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