Excel: Hiding worksheets, conditional on the content of a cell


Hi, I think people have asked broadly similar in the past but most questions seem to be about changing the content of a single cell. I have 10 worksheets of which I would like 9 normally hidden. On the first sheet I have a row of 10 cells, C7 to L7 (lets call them 1-10). All but the first cell, C7, will be normally empty. If a number is placed in to any of the other cells, D7 to L7 (2-10), I would like a corresponding worksheet to be unhidden. If the cell is empty then I would like the worksheet to be hidden again Can you help me with the VB code to get this to take place? Thanks! P


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of March 17, 2014.


For more resources for Microsoft Excel