Hiding a dropdown menu

  • Thread starter Thread starter Johanna Gronlund
  • Start date Start date
J

Johanna Gronlund

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
 
try;

Sub HideIt()
Sheet1.Shapes _
("Drop Down 573").Visible = _
Sheet1.Range("T51") = 1
End Sub
 
Hi and thanks for reply. I've copied this into a new module and assigned the
macro on the option button. However, nothing happens. There is no error
message but the dropdown menu is not hidden.

Johanna
 
Back
Top