ExcelBanter - Hiding Drop Down menu

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hiding Drop Down menu (https://www.excelbanter.com/excel-programming/291736-hiding-drop-down-menu.html)

Edgar[_3_]

Hiding Drop Down menu

I have a drop down menu called Drop Down 4.

What command can I use to hide this in a case select
statement?

TIA

Tom Ogilvy

Hiding Drop Down menu

Select Case i
Case 1
ActiveSheet.Dropdowns("Drop Down 4").Visible = False
Case Else

End Select

--
Regards,
Tom Ogilvy

"Edgar" wrote in message
...
I have a drop down menu called Drop Down 4.

What command can I use to hide this in a case select
statement?

TIA

All times are GMT +1. The time now is 07:29 AM.