View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mday
 
Posts: n/a
Default Hiding Rows when a cell = 0

hello,

I would like to hide a row when the first cell in that row = 0.

basically somthing along the lines of =IF(A1=0,hiderow,unhiderow)

I can hide rows but the file must be unprotected to change which rows are
hidden. With numerous people working with the file i would rather not risk
people deleting formulas on accident.