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 multiple option buttons 4
Enabling/Disabling Checkboxes 1
Problems executing commands on one file from another 11
Creating Temporary Userform with checkboxes 1
Disabling Events: Dangerous? 1
Enabling/Disabling Checkboxes on Forms 2
Enabling add-in causes excel to crash 1
Merging wordsheets in Excel 2007 9

Top