How to Hide/Un-hide a worksheet based on cell on another sheet.
Hi All,
I am trying to hide a worksheet based on the result of another cell.
So....
IF "supply" worksheet Cell E2 = 2 then I want "supply (2)" Worksheet to appear or become unhidden.
Fist time posting so please let me know if there is anything wrong with this post.
I've also tried a few different macros but couldn't get it working.
Many Thanks!
|