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.

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
__________________________

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.