Certainly, you knew you can assign a macro to a shape in Excel? If not, then this lesson will show you how to do that.
Anytime you are able to custom something, it leaves the door open to new ideas. In this case, you can design dashboards, games, and even automate tasks.
And, having control over the design improves the user experience.
In part of this lesson, you may see the term right-click. When we say right-click, we simply want you to click the button on the right side of the mouse.
If you do not have a right mouse button, then you can generally use a regular click (left-side) and press the keyboard shortcut Shift-F10.
For the purpose of this lesson, we suggest you use Excel 2007 or higher or compatible. Enjoy!
Below, follow the steps to set up a macro to work with a shape.
Finally, this is just the beginning. Since you have this knowledge, we expect you to do some great things.
Remember our other lesson on assigning a macro? You must click out of edit mode to run the macro from the shape.
If you had any trouble with this quick tip, then try it again. In addition, check out our additional resources listed below.
Assign a macro to a shape in Excel
by Excel Effects :: October 25, 2020