Floating Toolbar Questions

  • Thread starter Thread starter Shatin
  • Start date Start date
S

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.
 
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
 
Thanks for your help again, Rob!

Rob van Gelder said:
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
Click to expand...
 
Back
Top