Hi Don,
Thanks a lot for this,
Regards,
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Wednesday, July 11, 2012 1:13 PM
Subject: Re: $$Excel-Macros$$ switch on anf off calculation
sub
yourmacro()
Application.Calculation
@googlegroups.com
Subject: Re: $$Excel-Macros$$ switch on anf off calculation
Thanks for that but how to do this ? how to set it up, sorry but not very good
at it, I've just started to learn VB.
Can you help me?
Thanks
Pawel
From: ANKUR AGGARWAL
To: "excel-macros@googlegroups.com"
Sent:
3:05 AM
Subject: Re: $$Excel-Macros$$ switch on anf off calculation
Use this line in your macro :-
Application.Calculation=xlCalculationManual
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.
From: pawel lupinski
11 July 2012 7:03 AM
Subject: $$Excel-Macros$$ switch on anf off calculation
Hi All,
can you help me on this. I have quite large excel file, because there is a lot
of calculation, I'd like to switch off excel calculation and when I'll be
closing file schitch on calculation. I m
Hi All,
can you help me on this. I have quite large excel file, because there is a lot
of calculation, I'd like to switch off excel calculation and when I'll be
closing file schitch on calculation. I mean by macro (manually I know how to do
this :) )
thanks a lot
Pawel
--
FORUM RULES (9
