Hi Mark,

I know the problem is already sorted, but on my machine (also XL 2002), the
CommandBar with index=54 is "AutoCalculate". Anyway, I should have used the
name and not the index #. Sorry for the confusion....

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark Driscol wrote:
That should have been "How would doing a reset on CommandBars(54)
affect the statusbar, then?"

Mark


"Mark Driscol" wrote in message
...
Jake,

A question for you. On my computer (Excel 2002), running

Application.CommandBars(54).Name

yields "Pattern." Doing a reset on CommandBars(54) would appear to
affect the statusbar, then?

Thanks.

Mark


"Jake Marx" wrote in message
...
Hi Mark,

Does executing the following statement fix the problem?

application.CommandBars(54).Reset

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mark Driscol wrote:
Excel 2002

I have a friend whose Excel won't display the sum, average, etc.
of a highlighted range in the statusbar. Also, you can't right
click the statusbar to get a pop-up menu to change the function.

I have searched the Microsoft knowledge base and this newsgroup,
but can't find anything on it. Any suggestions?

Thanks,

Mark