Use a cell to hide or unhide a cell

[Wouldsman]

Is it possible to have my VB code look at a cell on my active sheet to determine whether or not a sheet should be VeryHidden or not?

So if Sheet1 Cell L40 is blank sheet2 is Veryhidden but,
if Sheet1 Cell L40 = "tool" sheet2 would be un hidden.

My thought process here is that I need to work on my VeryHidden sheet on a regular basis
and if I can enter a code into one cell that would allow me access to sheet2 that would make life much easier.

[nathansav]

Yes, you'll need to do this in the Worksheet_Change event on SHeet1

and

Please Login or Register  to view this content.

Not tested in Excel.

[Miroslav R.]

Hi there,
done with following code assigned to worksheet change event on sheet1:

Please Login or Register  to view this content.

Book1.xlsm

Hope it helps!