Hide or Unhide sheets dependent on a cell value

Hi,
I need help with some VBA code that will hide and unhide worksheets dependent on the value of a cell.
For example, if cell A1 in worksheet AAA contains a zero, hide worksheet BBB but display worksheet CCC.
But if cell A1 in worksheet AAA does not contain a zero, display worksheet BBB but hide worksheet CCC.
Many thanks for any assistance.
Steve

You can use a WorkSheet Change event like below.

Modify this as needed. This goes in the code of the sheet AAA that you are monitoring, not a Module

Please Login or Register  to view this content.

Thanks ptmuldoon, I have to leave right now but will give this a go tomorrow!