Using GroupName
That would have been my guess as well.
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
ole.visible = True
?????
Noemi wrote:
Hi Tom
Is there a way of also making it visible as a group.
Thanks
Noemi
"Tom Ogilvy" wrote:
No, but you could do
for each ole in OleObjects
if typeof ole.Object is MSForms.OptionButton then
if lcase(ole.Object.GroupName) = "testing" then
ole.visible = False
end if
end if
Next
--
Regards,
Tom Ogilvy
"Noemi" wrote in message
...
Hi
Is it possible to use the groupname to be able to make the option
buttons
visible on a worksheet rather than the individual optionbutton names.
ie
optCheck, optHold, optNew
groupname = Testing
is there away to do the following
groupname(testing).visible = true
which makes the 3 option buttons visible.
Thanks
Noemi
--
Dave Peterson
|