Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When calculating a large spreadsheet there is a message that shows up in the
task bar on the lower left side that says "Calculating Cells : 20%" and gives the percentage of completion. I was wondering if there is a way to use this through VB code. I have several sheets in a workbook that all get updated by changing a master date. I would like to select sheet 1 and when the task bar message reaches 100% select sheet 2 and so on for each sheet. I think I am running into memory problems with all sheets trying to update at the same time, and I was hoping this may be a fix for my problem. Any suggestions would be appreciated. Vince |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
100% cpu usage | Excel Discussion (Misc queries) | |||
dialog box for active cell task to speed repeditive task | Excel Programming | |||
Memory usage | Excel Programming | |||
SQL - TOP 1 Usage | Excel Programming | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |