Check calculation status

[Merkling, Steven]

I am sorry but I am going to answer a question with a question.

Why wouldn't you want to force a calculation before print.

That it would always be calculated before it prints.

-Merk
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

 

[Merkling, Steven]

If you wanted to do that it would look something like this (in the workbook code page)

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.Calculate 'For all workbooks
Me.ActiveSheet.Calculate 'For the activesheet
Me.Sheets("Sheet1").Calculate 'For one specific sheet
Me.Sheets("Sheet1").Rows(1).Calculate 'For one specific row
Me.Sheets("Sheet1").Range("A1").Calculate 'For one specific range
End Sub

HTH
-Merk

I am sorry but I am going to answer a question with a question.

Why wouldn't you want to force a calculation before print.

That it would always be calculated before it prints.

-Merk
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

 

[Jeff]

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