Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

Add Tools to Quick Access Tool Bar(Excel Top Bar)

You can also add the “Com­mands” or “Tools” to “Quick Access Tool Bar” (top nav bar) in your excel sheet and it will be placed next to “Save” or “undo” icon in the excel sheet and their fore it will be easy for you to use it, it will be like short­cut.
Below are the fol­low­ing steps you need to fol­low to add com­mands to your excel “Quick Access Tool Bar“
Main Menu -> Excel Options

Excel-VBA-MACRO-Add Tool or command to excel - 1

Excel-VBA-MACRO-Add Tool or com­mand to excel — 1



Customize->Select “All Com­mands” from the drop down menu at the right panel   

Now Select the com­mands or tools which you need from the list and and click the Add but­ton, here i am select­ing “But­ton (Form Con­trol)” and “Check Box(Form Control)”.

Excel-VBA-MACRO-Add Tool or command to excel - 2

Excel-VBA-MACRO-Add Tool or com­mand to excel — 2

Notice you will get your com­mand added to “Quick Access Tool Bar”.

Excel-VBA-MACRO-Add Tool or command to excel - 3

Excel-VBA-MACRO-Add Tool or com­mand to excel — 3

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: