Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

invisible toolbar

peljopeljo Member Posts: 6
With my command DoCmd.ShowToolbar "Toolbar1", acToolbarYes i make my
toolbar Toolbar1 visible.I want at the same time make all other
toolbars on the screen invisible,regardless how they are
called.Sometimes i have
different toolbars shown and i am interested in a command that does
not refer toa specific toolbar, but makes all the toolbats on the
screeninvisible.Is it possible ?

Comments

  • HackmanCHackmanC Member Posts: 441
    Hide all others ...

    [code]
    Public Sub ListCommandBars()

    ' Purpose: Lists all available command bars in
    ' this Office application.

    Dim objCommandBar As Office.CommandBar
    Dim strResults As String

    Debug.Print "Command bars in this application:"

    For Each objCommandBar In Application.CommandBars

    Debug.Print objCommandBar.Name & _
    " (" & GetCommandBarType(objCommandBar.Type) & ")"

    Rem objCommandBar.Visible = False ' *** Check the object model.

    Next objCommandBar

    End Sub
    [/code]

    ---------
    : With my command DoCmd.ShowToolbar "Toolbar1", acToolbarYes i make my
    : toolbar Toolbar1 visible.I want at the same time make all other
    : toolbars on the screen invisible,regardless how they are
    : called.Sometimes i have
    : different toolbars shown and i am interested in a command that does
    : not refer toa specific toolbar, but makes all the toolbats on the
    : screeninvisible.Is it possible ?
    :
    :

    [red]Good luck![/red]
    [blue]Hackman[/blue]

Sign In or Register to comment.