Posted to microsoft.public.excel.programming

Ward

external usenet poster

Posts: 21

Disable Auto Calculate w/.enablecalculation?

I am needing to disable 5 worksheets from being automatically calculated due
to the massive amounts of formulas each holds. I would still like for excels
default setting Auto Calculate to remain active. I have attempted to set each
sheets .EnableCalculation property to False - without luck. Any input would
be greatly appreciative, thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disable auto-update	Jamal	Excel Programming	1	January 5th 08 01:21 AM
macro to disable auto refresh	Patrick Bateman	Excel Programming	12	September 7th 07 02:50 PM
Disable Auto Calculate Office 2004 Mac	[email protected]	Excel Programming	0	June 13th 07 03:03 PM
Disable Auto Refresh Dialog	Atchleykl	Excel Programming	0	September 13th 06 05:20 PM
Disable Auto Macro	mike_cutting-edge[_2_]	Excel Programming	1	February 15th 05 03:07 AM

All times are GMT +1. The time now is 06:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us