View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default floating toolbar to stay put

Boris,

You can plant it where you want.
You need to apply the .Position, .Left, and .RowIndex
properties to the CommandBar during the Workbook Open event.
You will still be able to manually move the toolbar.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"BorisS"
wrote in message
I have an add-in which created a toolbar that lists all my worksheets in it
(nice little piece). It creates the toolbar, which is floating. Then I can
dock it anywhere, but when I close and restart Excel, it appears floating
again. Any steps I can take to plant it firmly, like my built-in toolbars
seem to do when I place them somewhere?
Thx.
--
Boris