Conditionally Hide Columns

Hi Gos

Sorry about the delay. Got called away.

Try this out.

I don't know what cells to lock and what your list drop downs rules are (I may have lost some while testing)

1/. I have added column "Q" to the macro activation, it should hide the columns based on "D" in the same row, as does column "D" with "Q".

Don't know if you need this, but it seemed logical to me. It is fairly obvious how to cancel this.

2/. I have made your new button toggle hide/unhide columns "S:CQ"

3/. The sheet will be protected when it is opened. To make changes to the sheet use unprotect (Password = "test") don't protect it again. Save/Close/Re-open to check changes. Same with changing the password in ThisWorkbook

4/. You should also Password protect the VBa to prevent any adventurous user going into the code and finding sheet Password.

Let me know how you get on.

Regards
Alistair