Thread: Hiding a row when a cell has a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default 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


Reply With QuoteReply With Quote