How 2 Fix/Jam a custome ToolBar?
 

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!)

How 2 Fix/Jam a custome ToolBar?
 

Look at the .position property for the toolbar.

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

FARAZ QURESHI wrote:

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!)

--

Dave Peterson

How 2 Fix/Jam a custome ToolBar?
 

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

"FARAZ QURESHI" a écrit dans le
message de news: ...
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!)