unhide sheet conditionally?

[ACLrecon]

Is there a way to have a hidden sheet reveal itself automatically
depending on the value of a cell in another sheet that's visible?

Thanks.

 

[Ken Wright]

Not by means of any formulas - You would need to use code (VBA) with an
event macro (ie one triggered by some specific event such as calculation or
change etc).

Example:-

http://www.mvps.org/dmcritchie/excel/event.htm

Regards
Ken.................