View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
musa.biralo musa.biralo is offline
external usenet poster
 
Posts: 55
Default Toolbar is floating every time when excel is opened, how to dock?

Hi there,
Macro generates the toolbar and this is done by calling
"create_toolbar" from a module. The call "create_toolbar" is in
"Workbook_Open" event...as a result the toolbar is recreated/
repositioned as floating.... I tried protection/position properties
but ..nothing really helped....

Recreating of toolbar is ok but not the repositioning... Is there a
way to remember the last docking position and save that in the addins
file... so that the x and y or something similar can be pulled from
the xla. OR just to find out the best fit docking position....

your support is triple appreciated. Thanks!

musa.biralo