View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claude Claude is offline
external usenet poster
 
Posts: 36
Default Exclude cells from calculation?

Hi all

Is there a way to exclude certain cells in a worksheet
from calculation when f9 is hit? I have cells referencing
to an external data source which result in errors when f9
is hit and the data source is not available.
Is it possible to stop calculation from occuring with
Workbook_SheetCalculate() or Worksheet_Calculate()?