Calculate Individual Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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.
Click to expand...

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
__________________________
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Calculation 5
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Handling a worksheet calculate event in XLA code 4
Macro that unhides a sheet and takes the user to that sheet 2
Overriding the calculation state 6
Excel Calculation taking too long 1
Calculate does not work consistently 1
Status Bar shows "Calculate", but calculation is set to Automatic 1

Back
Top