View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Enabling/Disabling OptionButtons, CheckBoxes etc. in another works

You need to include the sheet name in the instruction

Sheets("Sheet3").CheckBox1 = True

"Will" wrote:

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".