What is the name of the little menu at the bottom right if a sheet? Can I
edit its properties? I want to offer choices besides Sum, Count & such. If I
just knew what the darn object was called€¦€¦

statusbar

--
Don Guillett
SalesAid Software

"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..

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..

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..

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..

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..

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..
|
|
|
|
|
|
|