How 2 Fix/Jam a custome ToolBar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!)
 
Look at the .position property for the toolbar.

With cb 'dimmed as an application.commandbar
.Visible = True
.Position = msoBarBottom 'or msoBarTop ...
...
 
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
 
Back
Top