macros in multiple worksheets

G

Guest

I want to link a macro in worksheet1 to a macro in
worksheet2 anyone know how? For instance if a checkbox in
sheet1 is true I want to disable the checkbox in sheet2
and vice versa.

thanks
 
B

Bob Phillips

Unless you have your macro is in worksheet code modules (and why would you?)
the macro applies to the workbook.

So you can run

Worksheets("Sheet2").Checkbox1.Enabled = False

If you are referring to control events, then the code is the same, just
invoked from the control event on Sheet1.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top