Hide or unhide sheets based on changing cell values

[bakarken]

Hi

I have a master sheet where cells E6 to E20 have either got the word 'HIDE' or 'UNHIDE' in them. Cells D6 to D20 have the names of each of the other 15 sheets in the workbook.

The 'HIDE' and 'UNHIDE' cells are displayed based on IF formulas i.e. =IF(E2=1,"HIDE","UNHIDE")

If possible, I'd like a VBA where each of the sheets will hide or unhide depending on the value on the master sheet

Thanks in advance!

 

[igold]

I echo what Fluff said, I am glad it that it is working. Thanks for the feedback.
@Fluff

Thanks... again!