View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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