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?


  • Re: Docking A Custom Toolbar

    Take a look at the Position property in Help:

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

Participate now!

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