Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Delhi
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Changing default 'smiley' buttons in Excel 2003 Custom toolbars

    I am using Excel 2003 and have created 2 macros.
    I have created a custom toolbar and created two buttons on it and have assigned these 2 macros to these two buttons.
    The problem is both are default 'smiley' buttons.
    I need to change one of them else I would not know which runs which macro
    Also, need to change the tool tips for these buttons.
    Can anyone help me?

  2. #2
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts
    When you are in Toolbar Customize mode then right-click the toolbar button for options on changing the button-face ( you can manually edit the button face too ).

    As for changing the tool tip, you'll need to do that in VBA ... see here:
    http://support.microsoft.com/kb/171595

  3. The Following User Says Thank You to GlennB For This Useful Post:

    wizard01 (2011-12-09)

  4. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The tooltip defaults to whatever name you give the button so there should be no need for VBA.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. The Following User Says Thank You to rory For This Useful Post:

    wizard01 (2011-12-09)

Posting Permissions

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