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
|