ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unassigning / Removing Macro from Shape (https://www.excelbanter.com/excel-programming/300940-unassigning-removing-macro-shape.html)

Harrison Davis

Unassigning / Removing Macro from Shape
 
Using Excel 2002, I drew a shape and assigned a macro to that shape.

I would now like to leave the shape in the file because it contains
text, but remove or unasign the macro from the shape.

How can I do this without deleting the macro code?

Bob Phillips[_6_]

Unassigning / Removing Macro from Shape
 
Right-click the shape, got to the Assign Macro option, and clear the edit
box.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Harrison Davis" wrote in message
om...
Using Excel 2002, I drew a shape and assigned a macro to that shape.

I would now like to leave the shape in the file because it contains
text, but remove or unasign the macro from the shape.

How can I do this without deleting the macro code?





All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com