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

hi,
see this site.
http://www.exceltip.com/exceltips.ph...ategory&ID=205

regards
FSt1

"Vince" wrote:

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

Vince,

I don't think you can trap the percentage complete number, if that is what
you are after. You can, however, write messages to the status bar yourself
using application.statusbar.

AFAIK, Excel's calculation engine is optimised. It rather depends on what
you are doing, but I suppose that if there are no cross sheet dependencies
you could write yourself a calculation control macro that would calculate
one sheet at a time, but I doubt that there is any great benefit to this.

Robin Hammond
www.enhanceddatasystems.com

"Vince" wrote in message
...
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

Vince,
See if this one will help. Shows some %'s in task bar.

http://vbaexpress.com/kb/getarticle.php?kb_id=87


Vince Wrote:
When calculating a large spreadsheet there is a message that shows up i
the
task bar on the lower left side that says "Calculating Cells : 20%" an
gives
the percentage of completion. I was wondering if there is a way to us
this
through VB code. I have several sheets in a workbook that all ge
updated by
changing a master date. I would like to select sheet 1 and when th
task bar
message reaches 100% select sheet 2 and so on for each sheet. I thin
I am
running into memory problems with all sheets trying to update at th
same
time, and I was hoping this may be a fix for my problem. An
suggestions
would be appreciated.

Vinc

--
Piranh

-----------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2043
View this thread: http://www.excelforum.com/showthread.php?threadid=40023