macros in multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do Excel define the application area? 3
macro to hide columns and/or worksheets 4
matching multiple columns on different worksheets 1
Paste into next blank row in a different worksheet 10
trigger worksheet activate event in another worksheet 2
Slow code when used as VBA code instead of macro (copying visible columns) 3
Through a command button hiding rows 6
Copy a row down a column for the same number of rows of data in another workshee 6

Back
Top