Thread: Need to have control of the calculation to specific ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Udo Udo is offline
external usenet poster
  
Posts: 48
Default Need to have control of the calculation to specific ranges
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

Reply With QuoteReply With Quote