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