Hiding a row when a cell has a value
 

Hi all,

I would like to hide a row when an option is ticked/unticked. For example;

if(a1="x", row20=shown, row20=hidden)

Thanks for any help,
Souljacked

Hiding a row when a cell has a value
 

You can use a worksheet_change event macro to do this. More info..
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Souljacked" wrote in message
...
Hi all,

I would like to hide a row when an option is ticked/unticked. For example;

if(a1="x", row20=shown, row20=hidden)

Thanks for any help,
Souljacked