Calculating

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
 
D

Don Guillett

change when you enter and exit in the ThisWorkbook module
workbook_open
beforeclose
 
L

Leo Heuser

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.
 
D

Dave Peterson

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.)
 
Top