Hi Udo,

Yes, it probably would be best to be able to only have recalculation in the
activesheet ... but how ...
I surley want to have calculation on the cells you see on the sheet ...
/Regards


"Udo" skrev i meddelandet
ups.com...
Hi Maria,

a quick win for A and C would be to generate a macro which will be
executed whenever you open the specific workbook. There, you could
state Application.Calculation=xlCalculationManual
Then the workbook will be re-calculated only after pressing F9 or after
closing the workbook.
Re. question B I do not have a quick answer available yet.

Udo