Thread: assign macro to button programmatically
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zone[_3_] Zone[_3_] is offline
external usenet poster
  
Posts: 373
Default assign macro to button programmatically
I have a button on my worksheet from the Forms toolbar. I know I can use
ActiveSheet.Buttons(1).Caption="My Text" to set the button's caption. But
how do I set the button's macro to sub SpeakMsg? Excel XP. Thanks, James


Reply With QuoteReply With Quote