Question:
How do I Remove the ToolBar Gripper?

Answer:
By default, a toolbar will display agripper that is used to indicate that the tollbar can be "gripped" andmoved by the user. The gripper is cosmetic only, removing the gripperwill not disable movement of the toolbar. To modify where the toolbarcan be docked, if at all, you need to use the EnableDocking method discussed in KB article in previous post.

The ModifyStyle method is used to remove or replace the gripper of a toolbar. The styles that can be removed or added are stored in the XTPCommandBarStyle enumeration.



The code below removes the gripper from the menu bar and the first toolbar.

'Remove gripper from the menu bar
CommandBars.ActiveMenuBar.ModifyStyle XTP_CBRS_GRIPPER, 0

'Remove gripper from the first toolbar.  Note that Commandbars(1)
'is the menu bar
CommandBars(2).ModifyStyle XTP_CBRS_GRIPPER, 0

Question:
How do I Disable Toolbar Docking and Floating so that the Toolbar can not be Moved?

Answer:
The CommandBars.EnableDocking method is used to specify where a toolbar can be docked, and how it is displayed. The XTPToolBarFlags enumeration contains the different toolbar options that can be applied with the EnableDocking method. You can combine vaules to taylor to your needs, for example, you can specify that the toolbar can be docked only to the top or bottom of the application.

The picture below illustrates toolbars docked to several different locations in the application.


The code below illustrates how to limit a toolbar so that is can onlybe docked to the top and bottom of the application, or it can be afloating toolbar.

Dim ToolBar As CommandBar
    
Set ToolBar = CommandBars.Add("Standard", xtpBarTop)
ToolBar.EnableDocking xtpFlagAlignBottom Or xtpFlagAlignTop _
                      Or xtpFlagFloating

Dim ToolBar As CommandBar
    
Set ToolBar = CommandBars.Add("Standard", xtpBarTop)
ToolBar.EnableDocking 0