dynamic buttons

  • Thread starter Thread starter Noctos
  • Start date Start date
N

Noctos

I was wondering if it was possible to change the macro assigned to
button by linking it to the cell link value of an option button. Fo
instance if the user chose "yes" macro 1 will be assigned to a button
If they chose "No" macro 2 will be assigned to the button
 
Hi Noctos,

Yes it is. This assigns MacroB to a button

ActiveSheet.Shapes("Button 1").OnAction = "MacroB"



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
No (=not in a simple, safe way worth considering, almost everything is possible).

Let the button macro consider what the user has selected and call the proper macro.
 
Back
Top