View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Unable to unassign macro from shape

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.

"JT" wrote:

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