Search

How to change default Macro button icon in Excel Ribbon

 

The default Macro button icon in Excel Ribbon is shown in below image.

Default Macro Button Icon in Excel Ribbon

If there are too many Macros added to a Group in Excel Ribbon, it will become difficult to identify the Macro which you are looking for.

You may change the default icon used for your Macro button in Excel Ribbon by following below steps.

Step 1 - Right-click anywhere on Excel Ribbon and then select "Customize the Ribbon", as shown in below image.

Open Excel Options Change Macro Icon in Ribbon

"Excel Options" window is opened and its "Customize Ribbon" Panel is displayed as shown below.

Excel Options Window Customize Ribbon Panel

Tip

"Excel Options" window to customize Excel Ribbon can be opened by following methods also.

• Click the "File" tab in Excel Ribbon and then click "Options". Select "Customize Ribbon" Panel.

Or

• Right-click anywhere on the "Quick Access Toolbar" (except on "Customize Quick Access Toolbar" drop-down button). Click "Customize Ribbon".

Step 2 - Select the Macro which you want to change the icon from right-side list. Click "Rename" Button.

Modify Macro Icon

Step 3 - In "Rename" dialog box, select the icon you want to use for Macro from "Symbol" as shown in below image. You can choose a relevant icon for your Macro button from a variety of icons from "Rename" dialog box, as shown in below image. Click "OK" to change the Macro button icon.

Select Icon from Symbol box

Step 4 - Verify whether the icon is changed for the Macro in right-side list of "Excel Options". Click "OK" Button to finish, as shown in below image.

Icon changed in Excel Options

The default icon is changed and newly selected icon is assiged to the Macro in Excel Ribbon, as shown in below image.

Macro button icon changed in Excel Ribbon

Click the following link to learn How to add a Macro to Excel Ribbon.

Related Tutorials
• Excel Ribbon explained in detail
• Responsive Nature of Excel Ribbon
• Different types of Buttons in Excel Ribbon
• How to collapse Excel Ribbon
• How to Customize Excel Ribbon
• How to create and add a Custom Tab in Excel Ribbon
• How to create and add Custom Group in Excel Ribbon's Tab
• How to add a Command button to Excel Ribbon's Group
• How to reset Excel Ribbon customizations
• How to Import/Export Excel Ribbon Customizations
• How to add a Macro to Excel Ribbon
• How to change the position of Tab on Excel Ribbon
• How to change the position of Group on Excel Ribbon's Tab
• How to change the position of Command button in Excel Ribbon's Group
• What is Excel Ribbon Contextual Tab, Excel Ribbon Tool Tab
• Excel Formula Bar explained in detail
• Excel Status Bar in brief
• Excel Status Bar explained in detail
• Excel Quick Access Toolbar (QAT)
• Excel Backstage View