Unable to unassign macro from shape

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

Dear all

I have a shape in my workbook which has a macro assigned to it. I did
this by right clicking the shape, selecting "assign macro" and then
choosing the appropriate macro.

My problem is that I am now unable to undo this. I can assign a
different macro to the shape using the same approach but cannot set up
the shape so that it is not linked to any macro. Does anybody know
how to "unassign" macros from shapes?

Thanks

JT
 
the shape has a name associated with it which is the same as the macro. You
need to delete the macro or change the name of the macro on the first line of
the macro to break the link.
 
Right click the shape and select Assign macro. The dialog will open up. The
combo box at the top shows the Currently assigned macro. Delete the reference
(it should already be selected so just hit delete) and select OK.
 
Right click the shape and select Assign macro. The dialog will open up. The
combo box at the top shows the Currently assigned macro. Delete the reference
(it should already be selected so just hit delete) and select OK.
--
HTH...

Jim Thomlinson







- Show quoted text -
Click to expand...

Thanks
 
Back
Top