+ Reply to Thread
Results 1 to 2 of 2

Macro button to replace ribbon button

  1. #1
    Registered User
    Join Date
    03-07-2022
    Location
    Latvia
    MS-Off Ver
    Office 365
    Posts
    1

    Macro button to replace ribbon button

    Hello, I'm very new to VBA and Macros in Excel I was wondering if I can put a button inside the worksheet that acts as one of the buttons on the ribbon/top menu?
    For example the Developers Tab and Import and Export.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,331

    Re: Macro button to replace ribbon button

    Yes, you can. The simplest way is to simply call the commandbar control:

    Please Login or Register  to view this content.
    for example.
    Everyone who confuses correlation and causation ends up dead.

+ 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. Macro button in Ribbon created, but not working.
    By marshak in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-13-2018, 10:15 PM
  2. [SOLVED] Macro runs using F5 but not when clicking custom button on ribbon
    By 6StringJazzer in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2017, 09:39 AM
  3. [SOLVED] Adding macro button to the Excel ribbon.
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2016, 10:08 PM
  4. [SOLVED] Short-Cut Key vs Ribbon Button Macro Activating
    By riqrat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2015, 01:39 PM
  5. Assign a relative macro to a Ribbon Button
    By CaioToOn! in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2011, 05:13 PM
  6. Assigning a macro to a custom button in 2007 ribbon
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2009, 05:50 AM

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