• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to hide formula being displayed when workbook is opened?

Netsy

New Member
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 these cells?
 
Top