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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Shatin" wrote in message
...
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.