Results 1 to 2 of 2

Display Custom Toolbar Linked to a Specific Workbook

Threaded View

EMBBERWYN Display Custom Toolbar Linked... 04-22-2022, 01:39 PM
AliGW Re: Display Custom Toolbar... 04-22-2022, 04:33 PM
  1. #1
    Registered User
    Join Date
    06-30-2020
    Location
    Berwyn, PA
    MS-Off Ver
    365
    Posts
    14

    Display Custom Toolbar Linked to a Specific Workbook

    I have created customized toolbar “Specific Workbook” to be linked to a specific workbook. How can I display “Specific Workbook” toolbar upon opening “Specific Workbook.xlsm?” When any other workbook is opened their default Excel toolbar will be displayed.

    I tried Workbook_Open and Workbook_Activate private subs with Application. CommandBars and I couldn’t get it to work.

    I found the code below on this website and slightly modified it.


    
    Private Sub Workbook_Activate(ByVal Wn As Window)
    Application.CommandBars(“Specific Workbook”).Visible = True
    End Sub
    Private Sub Workbook_Deactivate(ByVal Wn As Window)
    Application.CommandBars(“Specific Workbook”).Visible = False
    End Sub
    I couldn’t get the above routine to work.

    What I need is a routine that will display “Specific Workbook” toolbar when "Specific Workbook”.xlsm" is opened if the user opens any other workbook their default toolbar will be displayed.

    Any suggestions?

    Thanks for your responses

    Ed
    Last edited by EMBBERWYN; 04-22-2022 at 05:08 PM. Reason: No code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-21-2017, 03:36 PM
  2. Adding a button to the toolbar that is linked to a specific macro
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2010, 10:54 PM
  3. [SOLVED] Attaching a Custom Toolbar to Workbook
    By Mogadeet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2009, 01:26 PM
  4. Isolating a custom toolbar to a specific spreadsheet
    By Gilgamesh in forum Excel General
    Replies: 3
    Last Post: 10-14-2005, 09:05 AM
  5. Assign a Custom Toolbar to only one WorkBook
    By Ken Soenen in forum Excel General
    Replies: 3
    Last Post: 09-28-2005, 09:05 AM
  6. [SOLVED] Displaying Custom Toolbar in Specific Worksheet
    By Thomas M in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2005, 03:06 PM
  7. How can I attach a custom toolbar to only appear on one specific .
    By ABuia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1