Posted to microsoft.public.excel.programming

Chris Gorham[_2_] Chris Gorham[_2_] is offline

external usenet poster

Posts: 4

Detecting Calculation State

firstly, thanks for the invisible range names advice -
thats solved.
is it possible to detect the calculation state of a
workbook such that the macro will only make it recalculate
if it requires it. I run Excel 2000. 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
replace state names with state code abbreviations	se7098	Excel Worksheet Functions	3	July 25th 09 06:41 PM
Detecting Calc On or Off	dhstein	Excel Discussion (Misc queries)	5	April 22nd 09 10:41 AM
How can I show state-by-state data (as silos) on a map of NA	Rob	Charts and Charting in Excel	0	November 5th 07 03:41 PM
Converting State Names to State Abbreviations	aznate	Excel Discussion (Misc queries)	1	October 20th 06 06:52 AM
Detecting absentees	gracegift	Excel Discussion (Misc queries)	7	December 27th 04 11:35 PM

All times are GMT +1. The time now is 06:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us