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
__________________________