Help needed for macro+Worksheet_Change

[zoe73]

As being a newbie in advanced work with Excel I have a question.

I have a Validation Vlookup Drown down Menu and depending on the selection the user makes there I want that certain parts of my sheet are hiding.

To make it more clear I'll explain it with an example.

Drop down 1 options:

A
B
C
D
E

Vlookup drop down 2 options depending on the selection in drop down 1:

A1
A2
A3
B1
B2
B3
C1
C2
C3
D1
D2
D3
D4

Now I need something which hides different parts of the worksheet depending on the choice made here in drop down menu 2 (for example text applicable for selection B1 is in Cell G1:AB5 and Z28 while text applicable for selection B2 is in Cell M10 and N1)

I hope it is clear what I am trying to do.

Can somebody help?

 

[andre5]

Hi

you can only hide a full row or column.

If you really want to hide a section then try and make the font of those text the same as the back bround in that range, I would suggest you also then protect the sheet after changing the unprotected area and setting it so that they cant select those cells that is protected (You will still see the font if they highlight the block if they can select it.)

hope that helps