View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeff jeff is offline
external usenet poster
 
Posts: 44
Default Check calculation status

I have a large worksheet in Excel 97 that I have the
calulation setting set to Manual. From this worksheet a
user prints a summary report, but often forgets to hit F9
to recalc the sheet. Could someone tell me how I can have
text appear in a cell that says something like "worksheet
was not calculated"? So that if the user prints the
report without recalculating they can see that right on
the report.

Thanks for your help.

Jeff