View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TDC TDC is offline
external usenet poster
 
Posts: 14
Default VBA to hide a row in different worksheet

I need a VBA code to automatically hide or unhide a row in one sheet based
upon the value is a cell on another sheet.

Example:

If Sheet1, cell A1 = 0, then Sheet2, row 5 is hiden.
If Sheet1, cell A1 0, then Sheet2, row 5 is visible.

Suggestions?