Enabling/Disabling OptionButtons, CheckBoxes etc. in another works

W

Will

My Excel workbook has several worksheets,
each of which contains several OptionButtons, CheckBoxes etc.

What I am looking for is a Macro, which runs from one worksheet
and which changes (enables, disables) the
OptionButtons/Checkboxes/etc. in the other worksheets.

Is this possible?

I have tried commands like
OptionButton1.Enabled = False
but I am geting "runtime error 424 -- object required".
 
J

Joel

You need to include the sheet name in the instruction

Sheets("Sheet3").CheckBox1 = True
 

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

Enabling/Disabling Checkboxes 1
Unable to run macro in Excel 2007 0
Enabling add-in causes excel to crash 2
If statement works here, case doesn't 1
Autorun macro does not autorun... 5
Merging wordsheets in Excel 2007 9
How to Correctly Enable/Disable controls with Form_Current 1
Unable to run macro in Office 2007 1

Top