macros in multiple worksheets
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)
wrote in message
...
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
|