Unhide/Hide Sheet Based On Value In Cell

Hi,

I have a sheet called "Summary", there is a cell, AR8, of that sheet that is linked to other sheets. If AR8 of "Summary" has a value other than 0 I would like it to unhide. But if the value goes back to 0 again I would like it to hide itself again.

How can I do this?

Re: Sheet Unhide/hide Based On Value In Cell

Quote from jhenderson

This has been asked and answered many times
look at this link
http://www.ozgrid.com/forum/showthread.php?t=59178

Thanks very much, I actually looked at that one before posting, could not get it to work.[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]

Quote from Dave Hawley

There are at least 2 answers directly above you.

Thanks for your help dave, I could not get your code to work however. Is there something that needs to be adde to it besides sub and end sub?