Posted to microsoft.public.excel.programming

Kjeldc[_3_] Kjeldc[_3_] is offline

external usenet poster

Posts: 12

Disable/enable recalc

I have workbook with lots of sheets and formulas and it takes forever to
recalc the workbook, whenever a new entry is made in a cell. Is it possible
to disable recalc for the whole workbook, and then start it with a
controlbutton?

Vista Ultimate/Office 2007
--
My programming is self-taught and
my teacher was not very experienced. :-)

cheers,
Kjeld

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
Enable/Disable Macro	D	Excel Programming	2	January 11th 08 04:18 PM
Combo Box enable and disable	Vinod[_2_]	Excel Worksheet Functions	3	November 6th 07 05:30 PM
Enable/Disable macros	Adam	Excel Discussion (Misc queries)	2	March 11th 05 10:29 AM
SpinButton Enable/Disable	MikeL	Excel Programming	3	December 21st 04 02:51 PM

All times are GMT +1. The time now is 01:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us