View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Hiding a dropdown menu

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