Open toolbar w/workbook
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Open toolbar w/workbook

  1. #1
    Guest

    Default

     
    Hello, can anyone tell me how I can get a custom toolbar to open ONLY with a specific workbook? I don't want the workbook to remain open when I open the normal template.

    Your help is greatly appreciated!

    Thank you@

  2. #2
    Guest

    Default

      
    You require two macros... one that triggers automatically when the workbook is opened and another that is run automatically on closing the workbook.

    Note that the macro names Auto_Open and Auto_Close are predefined within Excel to run on the open and close events.

    Sub Auto_Open()
    Application.CommandBars("ToolBarName").Visible = True
    End Sub

    Sub Auto_Close()
    Application.CommandBars("ToolBarName").Visible = False
    End Sub

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com