Functions in Statusbar Won't Display

  • Thread starter Thread starter Mark Driscol
  • Start date Start date
M

Mark Driscol

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
 
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]
 
Jake,

I will try it tomorrow and let you know.

Thanks!

Mark


Jake Marx said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Is it possible that the statusbar isn't displayed:

Tools|options|view tab|check statusbar.
 
Thanks, Dave, I had checked that the statusbar is displayed. No functions
will display in it and you cannot right click on the statusbar to get a
pop-up menu.

Jake had mentioned trying to reset the statusbar, so I'd like to try that.
I'm not sure how the particular statement he provided will do it, so if you
or he can clarify that for me I would be grateful.

Thank you.

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

Mark


Mark Driscol said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
All, for some reason, today this is working on my friend's computer. Thanks
to all who responded.

Mark


Mark Driscol said:
Thanks, Dave, I had checked that the statusbar is displayed. No functions
will display in it and you cannot right click on the statusbar to get a
pop-up menu.

Jake had mentioned trying to reset the statusbar, so I'd like to try that.
I'm not sure how the particular statement he provided will do it, so if you
or he can clarify that for me I would be grateful.

Thank you.

Mark
Click to expand...
 
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 said:
That should have been "How would doing a reset on CommandBars(54)
affect the statusbar, then?"

Mark


Mark Driscol said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top