| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Individual Sheets
I have a workbook that contains numerous worksheets. I have calculate set to
manual. I would like to make it so that when the user presses F9, only the activesheet is calculated, otherwise it take an extremely long time for the calculation to complete. Thankyou in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Individual Sheets
On Sun, 12 Dec 2004 08:41:01 -0800, PosseJohn
wrote: I have a workbook that contains numerous worksheets. I have calculate set to manual. I would like to make it so that when the user presses F9, only the activesheet is calculated, otherwise it take an extremely long time for the calculation to complete. Thankyou in advance. I don't believe you can selectively use F9 to calculate just one sheet. Rather than F9, why not just put a CommanButton (from the toolbox) on the sheet which needs to be recalculated, and code the Click event of this button with Activesheet.Calculate Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Individual Sheets
SHIFT+F9 recalculates just the active sheet
See www.decisionmodels.com -- Kind Regards, Niek Otten Microsoft MVP - Excel "PosseJohn" wrote in message ... I have a workbook that contains numerous worksheets. I have calculate set to manual. I would like to make it so that when the user presses F9, only the activesheet is calculated, otherwise it take an extremely long time for the calculation to complete. Thankyou in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate individual sheets? | Excel Discussion (Misc queries) | |||
| Calculate to total individual lines | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Linear Mode
