Selective Display Of Cells In Excel
Posted on 2002-05-23
I have a problem with Excel.
I have a spreadsheet which has an Auto_Open module which selectivly hides or unhides cells dependant on the user. However I now need to unhide a cell based on what the user enters into another cell...it breaks down thus...
X4 is hidden but when B4>0 I want to unhide it.
Is there a cell event change event in Excel VBA that I can tap into to do this?