Deactivaion of recalc on load

's Computer Specifications

Hi Excel experts,

is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
"automatic" in the loaded sheet's options?

Thanks!

Michael

's Computer Specifications

Place this in the ThisWorkbook object in the on Open event:

Application.Calculation = xlCalculationManual
and in the Before Close Event
Application.Calculation = xlCalculationautomatic

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"Michael Hoffmann" wrote:

> Hi Excel experts,
>
> is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
> "automatic" in the loaded sheet's options?
>
> Thanks!
>
> Michael
>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
me.recalc	=?Utf-8?B?c3dhcw==?=	Microsoft Access Form Coding	0	3rd Nov 2007 06:56 AM
Help with recalc!	=?Utf-8?B?bWdrYWFt?=	Microsoft Access Forms	1	26th Jan 2007 01:41 PM
ReCalc'ing for almost everything I do	Conan Kelly	Microsoft Excel Worksheet Functions	7	5th Apr 2006 01:21 AM
RE: ReCalc'ing for almost everything I do	=?Utf-8?B?S2V2aW4gVmF1Z2hu?=	Microsoft Excel Worksheet Functions	0	4th Apr 2006 08:39 PM
Re: ReCalc'ing for almost everything I do	Niek Otten	Microsoft Excel Worksheet Functions	0	4th Apr 2006 08:37 PM