Reference guide.

Unassign a macro from an object in Excel – Quick tip

This quick tip shows you how to unassign a macro from an object in Excel.

---

Right-click note

In part of this lesson, you may see the term right-click. This means, click on the button on the right side of the mouse.

If you do not have a right mouse button, then you can use click on the object and press keyboard shortcut Shift-F10. Basically, Shift-F10 shows the shortcut menu.

---

For the purpose of this lesson, we suggest you use Excel 2007 or higher or compatible. Enjoy!

---

Steps to unassign a macro from an object in Excel

Follow the steps below to remove the assignment of a macro from an object.

1. Firstly, right-click on the object that contains the macro. Similarly, you can click on the object and press Shift-F10. After that, the shortcut menu appears.
2. And, select Assign Macro... from the shortcut menu. The Assign Macro dialog box opens.

3. In the Assign Macro dialog box, delete the contents in the Macro name: box.
4. Click OK.

---

Success!

So, where you successful in removing the assigned macro from your object? If not, then give it a shot again.

---

Additional resources

• Assign a macro to a command button in Excel
• Automate tasks with the Macro Recorder
• Insert a shape in PowerPoint
• Record a basic macro in Excel

---

Unassign a macro from an object in Excel
by Excel Effects :: October 25, 2020

---

Home