+ Reply to Thread
Results 1 to 2 of 2

Activate specific tollbar on Workbook Activate

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Activate specific tollbar on Workbook Activate

    Hello,

    I have a custom Tools created through a Sub in "ThisWorkbook" on "Activate".
    The Toolbar loads into the Add-ins.

    When I activate the workbook, by default, it activates the "Home" Toolbar tab.

    Wondering how I could change this default to the "Add-ins".
    Could you please advise?

    Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: Activate specific tollbar on Workbook Activate

    You code try using the ribbons ActivateTab command

    https://excelvbacode.wordpress.com/x...010-and-later/
    Attached Files Attached Files
    Last edited by Andy Pope; 11-11-2022 at 04:50 AM.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Activate word document from excel, run macro, copy results then activate excel
    By k1989l in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2016, 08:27 AM
  2. [SOLVED] how to activate a specific worksheet of a workbook
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2014, 11:51 AM
  3. Activate a specific sheet when opening a workbook.
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-19-2013, 10:38 AM
  4. Replies: 3
    Last Post: 10-10-2012, 05:10 PM
  5. How can I activate specific workbooks
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 02-24-2009, 09:12 PM
  6. Replies: 5
    Last Post: 06-05-2007, 10:06 AM
  7. [SOLVED] Workbook.Activate / Window.Activate problem
    By Tim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2006, 07:40 PM

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