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 Removed)HIS


"Jeff Wright" <(E-Mail Removed)> wrote in message
news:fq64d.341707$sh.92019@fed1read06...
> 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.
>

Nick,

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

Jeff

"Nick Hodge" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 Removed)HIS
>
>
> "Jeff Wright" <(E-Mail Removed)> wrote in message
> news:fq64d.341707$sh.92019@fed1read06...
>> 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.
>>
>
>