Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check calculation status
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 11/25/03 10:46AM 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check calculation status
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 Merkling, 11/25/03 10:16AM 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 11/25/03 10:46AM 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning calculation status | Excel Worksheet Functions | |||
Calculation appear on status bar when in autocalc mode | Excel Discussion (Misc queries) | |||
STATUS BAR LENGHT OF CALCULATION BOX | Excel Discussion (Misc queries) | |||
I want to return a value based on the status of a check box. If . | Excel Worksheet Functions | |||
Syntax to check protected status of a worksheet? | Excel Discussion (Misc queries) |