View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Macro to Click Button?

Private Sub ButtonA_Click()
'Your code for this event
ButtonB_Click
End Sub

HTH
--
AP


a écrit dans le message de news:
...
I can't figure out how to reference macro subs to macro subs (If
Possible???). I want to write a macro to an object that if selected,
also runs the attached macro to a seperate object. My goal in this is
to limit the amount of code in my spreadsheet by referencing code
already written. I may be going about this all wrong, please give me
some sugestions.

What I need is a macro that will click button A if I click button B...