How do I hide an Option Button?

  • Thread starter Thread starter Jeff Wright
  • Start date Start date
J

Jeff Wright

Greetings !

Without going into unnecessary details as to why, I have written a macro
which, among other tasks, hides 10 rows. Within these rows is an Option
Button (created with the Control Toolbox under View Toolbars) which I also
wish to hide. The rows hide without any problems, but the Option Button is
still visible. Is there a way to hide an Option Button while hiding rows? I
know that I can go into the Properties menu of the Option Button to hide it,
but that won't work in my macro (at least, not the way I tried!). Any help
is appreciated.

Thanks!

Jeff W.
 
Jeff

If you can set a property manually, you should be able to set it
programmatically. I hid the button1 on sheet1 using this

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


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Nick,

Many thanks! It does the job just perfectly! Your help is greatly
appreciated.

Jeff
 
Back
Top