How 2 Fix/Jam a custome ToolBar?

F

FARAZ QURESHI

Hi Every1

There is toolbar I have created via an addin, but it keeps on floating
whenever I open excel, creating distraction. Any mode or code piece that can
keep it fixed with others once it has been done so, so as to avoid the same
exercise everytime.

Thanx Guys (Girls as well!)
 
D

Dave Peterson

Look at the .position property for the toolbar.

With cb 'dimmed as an application.commandbar
.Visible = True
.Position = msoBarBottom 'or msoBarTop ...
...
 
P

papou

Hello
Set its position in your code, eg:
Dim MyBar As CommandBar
Set MyBar = Application.CommandBars.Add("Name", msoBarTop, , True)

See help on Add method applying to Commandbars.

HTH
Cordially
Pascal
 
Top