Hide / unhide cells based on a VBA code

[Metalgijs]

Dear all,

I build the code below with great help of some forum users.

I don't know if it is possible, but is it possible avoid the following "user friendliness bug" in my workbook?

The unhidden rows based on the answers given in column 5 20, 26 and 33 are hidden when I change the input of column 5 row 2 in "PO RECEIVED" and / or "TARGET ADJUSTMENT" and then back into "MAR", "LOST", etc.

I know it is based on my command to hide row 5:47, 7:47 or 20:47.

Cheers,
Martin

Please Login or Register  to view this content.

[Metalgijs]

Hi All,

Has one of you the knowledge to help me out? Or is my question simply too complicated

Cheers,
Martin