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.
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.