Macro that hides/unhides sheets depending on cell value

Hi

My knowledge of VB is pretty limited and I have tried with no success to find a macro that will unhide/hide sheets depending on a returned value in once particular cell. I have pretty much read every forum post and am still stumped.

So far I have got this but I know that Worksheet_Change doesn't run when the value of the target cell contains a formula (an IF "true or false" formula)

Please Login or Register  to view this content.

I have looked at Worksheet_Calculate but just don't know what to go.

Any help would be much appreciated.
Thanks
Ben

A calculate event would work like this:

Please Login or Register  to view this content.

Dom

@Ben, welcome to the Board, please remember to always encase VBA within CODE tags - given first post I've modified for you on this occasion.
Please be sure to check out the Forum Rules

You are correct that you would need to use the Calculate event - but obviously this has no Target per se and will fire for any number of reasons (not just because B59 has altered).

You could in theory use:

Please Login or Register  to view this content.

in the above I assumed by "TRUE" you mean is TRUE
(a Boolean as opposed to a text string)

Thanks guys, and soz for the oversight Donkey.

Dom - I have tried using that macro and it works the first time the formula returns TRUE i.e. to unhide sheets, but has problems when it changes to FALSE. I don't want to hide and unhide exactly the same sheets.

This is how mine reads:

Please Login or Register  to view this content.

I'm really stumped with this...

Thanks
Ben

From what I can tell only a handful of those sheets have their visibility altered

Please Login or Register  to view this content.