+ Reply to Thread
Results 1 to 3 of 3

How to change help text associated with a macro button on Quick Access Toolbar?

  1. #1
    Registered User
    Join Date
    08-01-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    76

    How to change help text associated with a macro button on Quick Access Toolbar?

    When I add a button to the quick access toolbar to call a macro, I notice that the help text (i.e. the text that appears when the mouse hovers over the button) is simply the name of the macro with which the button is associated (e.g. "Macro1").

    How can I change the help text to something meaningful for the user? (E.g. "This button sets the contents of Cell A1 to 'Hello World!'")

  2. #2
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    205

    Re: How to change help text associated with a macro button on Quick Access Toolbar?

    Right click on the macro button in the ribbon, select
    Customize The Quick Access Toolbar
    , Then click onto the macro in the right window, then click on the
    Modify
    button at the bottom of the window. Now edit the
    Display Name:
    in the Modify Button window. Be cautious of what you choose to display, it would be advisable to keep the macro name as part of the title.

  3. #3
    Registered User
    Join Date
    08-01-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: How to change help text associated with a macro button on Quick Access Toolbar?

    Doh! I failed to spot the really obvious Display Name input ...

+ 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. Icons for Quick Access toolbar
    By datafiend in forum Excel General
    Replies: 2
    Last Post: 10-29-2013, 01:56 AM
  2. problems assigning a macro to a button in the quick access bar
    By yossie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2011, 05:29 AM
  3. Excel 2007 : Quick Access Toolbar
    By PosseJohn in forum Excel General
    Replies: 2
    Last Post: 10-27-2010, 02:19 AM
  4. Excel 2007 : adding custom button to quick access toolbar
    By surfengine in forum Excel General
    Replies: 6
    Last Post: 02-02-2010, 02:50 PM
  5. Replies: 2
    Last Post: 03-26-2005, 04:06 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