VBA to change Button Macro assignment

[Ken Loomis]

I would like to change or remove a macro assignment to buttons.

I use this to change the text of a shape that I use as a button:

ActiveSheet.Shapes("Rectangle 5").Select
Selection.Characters.Text = "Mark Anomolies"

How would I change or remove the macro assignment to that button?

TIA,
Ken

 

[Norman Jones]

Hi Ken,

To change assignment, try:

ActiveSheet.Shapes("Rectangle 5")..OnAction = "MyNewMacro"


To Remove the assignment:

ActiveSheet.Shapes("Rectangle 5")..OnAction = ""

 

[L. Howard Kittle]

Hi Ken,

Try something like this.

To remove only:
ActiveSheet.Shapes("Rectangle 5").OnAction = ""

To change:
ActiveSheet.Shapes("Rectangle 5").OnAction = "New Macro Name"

HTH
Regards,
Howard