hi, how to hide formula being displayed when workbook is opened via VBA? cells A1: A3:A5:A7:A9:A10 have formulas added to. when click on cell A1: formula =IF(COUNT(K4:N4),"",B4) appear. but it can be changed. can i hide the formula for all...