Variably Hiding Cells
 

Hi!

I am working on an estimate sheet in Excel 2002 and would like to hide cells
based on responses to previous cells. Is there any easy way to do this in
Excel or should I be using a different tools? Does anyone know of a download
as I don't want to have extensive time vested in this solution?

Thanks,

Variably Hiding Cells
 

dYou can use the worksheet_change event to run a macro that reacts to the
user entering data in a cell(s). You can use the calculate event to check
specified cells and react to their value each time the sheet is calculated

http://www.cpearson.com/excel/events.htm for an overview of excel events.

--
Regards,
Tom Ogilvy


"Kim" wrote:

Hi!

I am working on an estimate sheet in Excel 2002 and would like to hide cells
based on responses to previous cells. Is there any easy way to do this in
Excel or should I be using a different tools? Does anyone know of a download
as I don't want to have extensive time vested in this solution?

Thanks,