View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Zachary_Harrison@putnam.com is offline
external usenet poster
 
Posts: 4
Default Unable to call Command Button's Click() method from a different sheet

Hi all-

I have a command button on Sheet1, with a Command1_Click() method. I
want to call that procedure from the Command2_Click() method which is
on Sheet2. Even with both procedures defined as Public, I am unable
to get this to work. I have tried

Call Command1_Click()
Call Command1.click

I get "Sub or function not defined" for Command1_Click() & "Object
Required" for Command1.click.

Any thoughts?

Thank you in advance!

Zacah