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