Highlight .position in the code and hit F1.

You'll see this:
Returns or sets the position of a command bar. Read/write MsoBarPosition.

Click on MsoBarPosition and you'll see these options.

msoBarBottom
msoBarFloating
msoBarLeft
msoBarMenuBar
msoBarPopup
msoBarRight
msoBarTop


I like the floating to make sure that the user (including me!) sees this new
toolbar.

"dok112 <" wrote:

Ok, I see how to do this now. But I do have a quick question. The
Position is set to floating. What would be the code to set it to be
attached to the toolbar?

With Application.CommandBars.Add
Name = "Transition Lab Week 1 Productivity"
Left = 200
Top = 200
Protection = msoBarNoProtection
Visible = True
Position = msoBarFloating

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson