Actually I don't think it's possible to put the result of a macro
calculation on the AutoCalculate spot to the right of the status bar. And I
don't think you'd want to put it in the status bar itself or you'd lose its
functionality, like telling you you're in a Copy, etc.

You'd have to construct an entire parallel autocalc feature, so, to agree
with your point Bob, you can't extend the built-in feature with more
functions.

--
Jim
"Don Guillett" wrote in message
...
| It can be done with a macro.
|
| --
| Don Guillett
| SalesAid Software
|
| "Bob Inwater" wrote in message
| ...
| Thanks guys. As far as I can tell I can not add orther functions such as
| Standard deviation
|
| "Don Guillett" wrote:
|
|
| so
|
| CommandBars("AutoCalculate").Controls("&None").Exe cute
|
| --
| Don Guillett
| SalesAid Software
|
| "Jim Rech" wrote in message
| ...
| I think it's AutoCalculate.
|
| --
| Jim
| "Bob Inwater" wrote in
message
| ...
| | What is the name of the little menu at the bottom right if a
sheet?
| Can
| I
| | edit it's properties? I want to offer choices besides Sum, Count &
| such.
| If I
| | just knew what the darn object was called..
|
|
|
|
|
|
|