LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Turning Automatic Calculation On after Workbook loads

I've got a large workbook which continually calculates cells while web
queries and other macros are executed upon document load. I can
disable Automatic Calculation in Workbook_Open and the worksheet opens
very quickly. After loading the workbook, I can turn automatic
calculation back on, but I have users of this workbook that are
probably not capable of doing this on their own. What I would like to
do is find a trigger to turn automatic calculation back ON, but I'm
not sure what that is. I tried using Worksheet_Change, but unless I
type into the cell, it doesn't show it as changing. This is probably
easy, but I haven't found anything in the help files or in this forum.

Any help or ideas would be greatly appreciated.
Dale.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Calculation - set to automatic for one workbook - manual for anoth dhstein Excel Discussion (Misc queries) 2 May 20th 09 08:35 PM
Prevent automatic calculation for workbook being opened Sergiy Excel Programming 10 September 5th 06 02:58 PM
Prevent automatic calculation for workbook being opened Sergiy Excel Programming 1 September 1st 06 02:11 PM
turning off automatic calculation when loading VBA add-in Lars Schouw Excel Programming 1 October 19th 05 06:30 AM
Turning off automatic calculation when opening a CSV file Will Excel Programming 2 September 20th 05 10:39 AM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"