Status Bar does not display worksheet status

Status Bar does not display worksheet status

Post by SE5vcnN3b3 » Sat, 13 Nov 2004 00:34:02


I have a user whose status bar no longer displays 'Ready', 'Enter', etc. I
cannot find any option to turn this on/off. The status bar is there, Num,
Caps, etc does display. Uninstalling & reinstalling Excell did not help.
Any ideas would be appreciated!
 
 
 

Status Bar does not display worksheet status

Post by Nick Hodg » Sat, 13 Nov 2004 00:44:40

Try

Opening the VBE (Alt+F11) and if there is not an immediate window showing,
go to View>Immediate window. (Ctrl+G). In here type

Application.StatusBar=False

This returns control of the status bar to Excel, as to why this may have
happened...??????? (Exit VBE an Excel)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
XXXX@XXXXX.COM

 
 
 

Status Bar does not display worksheet status

Post by SHVnaCBOb3 » Sat, 13 Nov 2004 01:03:07

Solved the problem! You made a frustrated user very happy!!! Thanks very
much!!