That's just the kind of info I needed.
Using it, I was able to get the buttons to go on and off.
Worksheets("Sheet1").OLEObjects("OptionButton1").Visible=False
for example.
All was well until I tried to also control the Value for the buttons.
It should have been so easy.
Worksheets("Sheet1").OLEObjects("OptionButton1").Value=False
But I get an error telling me Value is not a property of the object.
I think the two kinds of OptionButtons from the Form and Control
toolboxs are getting mixed up or something. Is this discussed
anywhere that you know of?
Should we always use the controls from the forms toolbox even if the
books only talk about the buttons from the Control Toolbox?
This is probably something simple that I'm just missing.