Create a custom command, assign it an icon, and included it in the Quick Access Toolbar in Excel


How do you create a custom command, assign it an icon, and include it in the Quick Access Toolbar (QAT) in Excel (2010)?

As an example, [Ribbon > View > Show (section)] includes the option to show or hide (Row & Column) Headings.

I looked for that as an existing shortcut (to add to my QAT) by going to:

        File > Options > Quick Access Toolbar > All Commands

However, although I looked under [Headings], [Hide Headings], [Show Headings], and [Unhide Headings], I could not find it.

Can someone explain how to create a custom QAT shortcut for that function?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
You were close.  

Excel 2016, Quick Access, Customize, All commands and select Hide & Unhide. Add to the Quick Access Toolbar and it is a pull down for all Hide and Unhide. I tested that here and it works as advertised.
Wayne Taylor (webtubbs)Commented:
Hide & Unhide hides the selected rows or columns.

What you are after is called "View Headings". The easy way to find it is to select "View Tab" from the "Choose commands from" list.
Rob HensonFinance AnalystCommented:
The above comments show the process for using an existing Command. For a Custom Command as suggested in the question you would first have to write the macro for that command. You can then use the above process for choosing the macro and assigning an icon.

There are limitations with Custom Commands using macros. For example, if you want the Custom Command to be available for all workbooks, the macro will have to be in your Personal macro workbook (Personal.xlsb). Those macros then have to be written in such a way that they are universal, eg not reliant on specific worksheets within a workbook.

In the above process, at the bottom of the right hand pane you will notice a Modify button. This is greyed out when using standard commands but will become available if you are choosing a macro driven command. The modification then allows the choice of an icon, albeit somewhat limited.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
WeThotUWasAToadAuthor Commented:
Thanks Rob.
Rob HensonFinance AnalystCommented:
Glad to be of help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.