How to hide columns based on a cells value in that column?

I am a fairly basic Excel user and I know this has been looked at and answered several times previously but I've tried several different pieces of code and none of them appear to work for me - probably my bad.

I want to hide a column if the value of a particular cell in that column is set to "OK". The value of the cell is set by the formula: =IF(C39>=C18,"OK","Needs Cover") and is for the range of cells (and thus columns) C17:AX17.

Do I need a Macro, some VBA, a module or something else and if so has anyone:
1. got a nice piece of code I'd be able to use and
2. how would I insert it into my worksheet?

Many thanks in advance.

1. In Excell, Press Alt + F11. The VBA editor window will appear
2. On the left hand side, locate the Project explorer panel
3. Find your woekbook, click the "+" to expand it if not already expanded
4. Locate the sheet object you want the code to run on, then double click that sheet
5. In the white area to the right, paste the code below:

Please Login or Register  to view this content.

Hi walruseggman,

Thank you very much for the quick response. As I said I am a basic user, the code works great when I press return on an individual cells formula, is there any way to make all the columns hide at the same time? Even better with a "hide button" of some description.

Thanks again,

dougielb

Sure. Insert a button and assign the following code to it ( a form control button will suffice):

Please Login or Register  to view this content.

Hi walruseggman,

Thank you even more. I was walking out the door last night when my email pinged so I have only just checked your latest post - it is awesome! The manager who asked for this will be thrilled! I have learned a lot already from you - I managed to put in a second button to unhide the columns as well.

Once again thank you for your time and patience with a learner - if I knew how to highlight this thread on the internet I would as it is the easiest code I've seen to achieve this (and the only one that works!).

dougielb