Macro to hide option button

[TomBP]

Hi,

I wrote a code to hide an option button but get an error (see attachment). I haven't got a clue what I'm doing wrong.

Thanks in advance for your help.

Sub hideButtonSheet1()
Worksheets("Sheet1").OptionButton1.Visible = False
End Sub

[Norie]

Try this, changing 'Option Button 1' appropriately.

 Worksheets("Sheet1").OptionButtons("Option Button 1").Visible = False

[TomBP]

Hi Norie,

That did the trick. Thanks for your reply.