We can execute a macro in many different ways, in this topic we will learn Running macro in Excel: From Macro Dialog and By assigning a short-cut key to the Macro
Running Macro in Excel: Executing or From Macro Dialog
Follow the below steps to assign a macro to a shortcut key:
Step 1: Go to Developer Tab or View Tab
Step 2: Select Macros from the Developer Tab or View Tab
It will open the Macro Dialog.
Step 3: Select a Macro which you want to execute it
Step 4: Click on Run” button
It will execute the selected macro.
Running Macro in Excel: Executing By Assigning a Shortcut Key to the Macro
Follow the below steps to assign a shortcut key to the macro:
Step 1: Go to Developer Tab or View Tab
Step 2: Select Macros from the Developer Tab or View Tab
It will open the Macro Dialog.
Step 3: Select a Macro which you want to assign a shortcut key
Step 4: Click on “Options…” button
It will show you Macro Options Dialog.
Step 5:Enter an alphabet in the Shortcut key text box
Example if you enter ‘q’, you have press Ctrl+q to execute your macro
Step 6:Then Press OK and Close the Macro Dialog
You are done! you can execute by pressing shortcut key (in this example it is Ctrl+q)
See the below image to understand the above steps:
We have many other options to execute a macro, we will see it in the advanced tutorials.
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
LIMITED TIME OFFER
Advanced Project Planning Templates
Excel Templates
120+ Project Management Templates Pack
Excel | PowerPoint | Word
ULTIMATE RESOURCE MANAGEMENT TEMPLATE
Excel Template
50+ Essential Project Management Templates
Excel | PowerPoint | Word
Project Portfolio Management Templates
Excel | PowerPoint Templates
50+ Excel Project Management Templates
Excel Templates