Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Floating toolbar disappear when embedded | Excel Discussion (Misc queries) | |||
floating toolbar to stay put | Excel Discussion (Misc queries) | |||
get rid euro conversion floating toolbar | Excel Worksheet Functions | |||
Floating Toolbar | Excel Discussion (Misc queries) | |||
PDF 4.0 Floating Toolbar | Excel Discussion (Misc queries) |