| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbar is floating every time when excel is opened, how to dock?
Thanks Jon!
Below was the perfect and i think more advanced solution so i adopt that... Thanks for the input. musa.biralo On Oct 9, 8:38 pm, "Jon Peltier" wrote: Change the macro so the commandbar is not floating MyCmdBar.Position = msoBarFloating '(or 4) but is docked somewhere MyCmdBar.Position = msoBarTop '(or 1) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ "musa.biralo" wrote in message ups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Floating toolbar and floating comment? | Excel Programming | |||
| excel should have a floating "custom view" toolbar | Excel Worksheet Functions | |||
| Dock a custom toolbar | Excel Programming | |||
| Dock a custom toolbar | Excel Programming | |||
| remove toolbar without excel opened | Excel Programming | |||
Hybrid Mode
