Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculation - set to automatic for one workbook - manual for anoth | Excel Discussion (Misc queries) | |||
Prevent automatic calculation for workbook being opened | Excel Programming | |||
Prevent automatic calculation for workbook being opened | Excel Programming | |||
turning off automatic calculation when loading VBA add-in | Excel Programming | |||
Turning off automatic calculation when opening a CSV file | Excel Programming |