Be the first user to complete this post

  • 0
Add to List

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

You can also add the “Commands” 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 shortcut.
Below are the following steps you need to follow to add commands 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 command to excel - 1

Customize->Select “All Commands” from the drop down menu at the right panel   

Now Select the commands or tools which you need from the list and and click the Add button, here i am selecting "Button (Form Control)" and "Check Box(Form Control)".

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

Notice you will get your command added to "Quick Access Tool Bar".

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



Also Read:

  1. VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers
  2. WorkBooks and WorkSheets
  3. How to Enable Macro in Excel
  4. VBA-Excel : 3D-Ranges – FillAcrossSheets Method
  5. VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)