| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Functions in Statusbar Won't Display
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
Jake,
I will try it tomorrow and let you know. 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
Is it possible that the statusbar isn't displayed:
Tools|options|view tab|check statusbar. 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
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 "Dave Peterson" wrote in message ... Is it possible that the statusbar isn't displayed: Tools|options|view tab|check statusbar. 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 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
All, for some reason, today this is working on my friend's computer. Thanks
to all who responded. Mark "Mark Driscol" wrote in message ... 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 "Dave Peterson" wrote in message ... Is it possible that the statusbar isn't displayed: Tools|options|view tab|check statusbar. 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 -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Functions in Statusbar Won't Display
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display formula Excel uses for internal functions (STDEV...) | Excel Worksheet Functions | |||
| FIX in Statusbar | Excel Discussion (Misc queries) | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
| display statusbar, scrollbars and formulabar | Excel Programming | |||
| StatusBar Msg? | Excel Programming | |||
Linear Mode
