Hiding a dropdown menu
 

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

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

Hiding a dropdown menu
 

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

--


"ozgrid.com" wrote:

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

.