try;
Sub HideIt()
Sheet1.Shapes _
("Drop Down 573").Visible = _
Sheet1.Range("T51") = 1
End Sub
--
Regards
Dave Hawley
www.ozgrid.com
"Johanna Gronlund" wrote in
message ...
Hello,
I am stuck and would appreciate your input.
I have an option button (Option Button 8566) and it is linked to cell T15
on
SheetResults. When the first option from the option button is chosen and
hence T15=1, Drop Down 573 should be visible. If T15 equals to anything
else,
Drop Down 573 should not be visible.
I know I need to write a macro but I am not sure where to start. Any
ideas?
Many thanks in advance,
Johanna