View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] chad.whyte@gmail.com is offline
external usenet poster
 
Posts: 2
Default Disable cell warning/error messages

Hello,

I have several hidden cells side-by-side that contain custom
calculations, and am receiving the error: "The formula in this cell
differs from the formulas in this area of the spreadsheet." Since
these cells are hidden, I don't want the user to see the small green
icon in the upper left corner of each cell, and the corresponding error
message.

How do I disable these errors through VBA so they are not visible?

Thank you,

Chad