Docking A Custom Toolbar

    I have built a custom toolbar which gets inserted the Excel file in opened and deleted when it closes.


    When it gets inserted it is just floating somewhere in the middle of the screen. I'm trying to dock it at the top of the screen under the Excel/File Name header.


    I've tried to run a macro to see what command it creates when I move the toolbars positioning but it does not recognize this movement.


    Does anybody have a solution?


    Thx

    Re: Docking A Custom Toolbar


    Take a look at the Position property in Help:

    Code
    For Each bar In CommandBars
    If bar.Visible = True Then
        If bar.BuiltIn Then
            bar.Position = msoBarTop
         Else
            bar.Position = msoBarBottom
        End If
    End If
Next

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login