Grey out a load of cells based on a drop-down choice

[sethmeister21]

Is there an easy way to grey-out (or deactivate) a load of cells based on another drop-down validation list? i.e. If I select "Microsoft Office" from a drop-down, it will then grey out the next few rows cells beneath it.

 

[lenze]

Typo in this line

Case "FTP": Range("Range1").Interior.Color Index = 15

should be

Case "FTP": Range("Range1").Interior.ColorIndex = 15

lenze

 

[sethmeister21]

lenze, thanks alot - it worked fine !

 

[bemp87]

Hi Lenze (or group),

Is it possible to do the same thing, but instead of gray them out, hide them based on the Drop Down selection?

I.E.

If user selects 'FTP' from the drop down menu, then rows 5-7 are hidden?

I am working on a project similar to what you responded to, except it is role based, if a user selects 'Employee' it will hide and only show the rows that apply to their role, if they select 'Manager' it will show all/applicable rows for that selection.

Typo in this line

Case "FTP": Range("Range1").Interior.Color Index = 15

should be

Case "FTP": Range("Range1").Interior.ColorIndex = 15

lenze