Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in multiple worksheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros is several worksheets | Excel Discussion (Misc queries) | |||
Macros and worksheets | Excel Discussion (Misc queries) | |||
macros affecting different worksheets | Excel Discussion (Misc queries) | |||
creating macros in multiple worksheets | Excel Worksheet Functions | |||
macros across multiple worksheets ... | Excel Programming |