Thread: How can I use VB to hide Row 57 if cell A53 has a value of 1?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dorothy Dorothy is offline
external usenet poster
  
Posts: 11
Default How can I use VB to hide Row 57 if cell A53 has a value of 1?
I have a pricing worksheet. If the person filling it out populates the QTY
field (cell A53) of the item in row 53 with a value of 1, then I want the
item in row 57 to "disappear", so it can't be selected also. Is there a VB
code I can use to accomplish this?

Thanks for your time!
Reply With QuoteReply With Quote