View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pmms
 
Posts: n/a
Default Do not allow a file to be saved if "ERROR" is in any field

I'm using IF conditions to check certain cells for negative numbers - if
they're negative the output is "ERROR". I wanted to know if there is a way
to prevent the file from being saved if "ERROR" is in any cell in the
workbook.