Thread: dynamic buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default dynamic buttons

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Noctos " wrote in message
...
I was wondering if it was possible to change the macro assigned to a
button by linking it to the cell link value of an option button. For
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.


---
Message posted from http://www.ExcelForum.com/