Calculating

  • Thread starter Thread starter Lars Peter Nielsen
  • Start date Start date
L

Lars Peter Nielsen

Hi

I wanted to hear if it is possible to set only one workbook to manual
calculation/updating while you have automatic calculation on the other
workbooks? When I change it either to manual or automatic it works for every
workbook I open.

Kind regards

Lars Peter Nielsen
 
change when you enter and exit in the ThisWorkbook module
workbook_open
beforeclose
 
Hej Lars Peter

Unfortunately no. It's a global setting.
In VBA however it's possible to recalc selectively.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
There is an option (I think it was added in xl2002) that allows you to stop the
calculation on a worksheet level.

Take a look in VBA's help for:
EnableCalculation

(It's in xl2002. If it's not in your help file, it won't be supported.)

But you actually have to toggle it back to True to get the worksheet to
recalculate.

(Tools|options|calculate tab|Calc Now (F9) won't work.)

(It sounds dangerous to me if you forget that it's set to false.)
 
Back
Top