Floating Toolbar Questions

[Shatin]

I have added a toolbar to a workbook with following code:

Set cbar = Application.CommandBars.Add(Name:="Custom Toolbar", _
Position:=msoBarFloating, Temporary:=True)
cbar.Visible = True

1. Why is that, even though I have Temporary:=True, the toolbar will not go
away when I close the file? I have to put a macro in the
Workbook_BeforeClose event to delete the toolbar.

2. When the workbook is opened, the toolbar appears somewhere in the middle
of the workbook, whereas I would like to it to be somewhere in the top right
corner. Is there any way I can control the initial position of a floating
toolbar? If so, how?

TIA.

 

[Rob van Gelder]

1. Temporary means that it wont remain after Excel is closed, not the
workbook. You should use Workbook_BeforeClose to kill your toolbar.

2. Set the Position argument to msoBarTop

 

[Shatin]

Thanks for your help again, Rob!

1. Temporary means that it wont remain after Excel is closed, not the
workbook. You should use Workbook_BeforeClose to kill your toolbar.

2. Set the Position argument to msoBarTop