Macro to hide columns based on cell values in the column to be hidden

Hi. I have a worksheet that I want to hide columns based upon the value of a cell in the column to be hidden.
i.e. if the value of the cells in range G5:DO5 is = "optl" then hide the column of that cell. Otherwise that column is to be visible.

Thank you!

Hi JCMus

Here is some simple code. It assumes the test value is stored in cell A1:

Please Login or Register  to view this content.

You could use this in a Worksheet_Change macro and activate it every time cell A1 changes. If you wanted to do this, copy the following in the the Worksheet's macros (i.e. in the sheet itself in the VBA Editor):

Please Login or Register  to view this content.

Regards, Rob.