Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Status bar does not display worksheet status

Status
Not open for further replies.

hughn

IS-IT--Management
Jan 19, 2004
9
US
I have user whose Excel Status bar no longer displays "Ready", "Enter", etc. It does display Num, Caps, etc, just not the status of the worksheet. It also doesn't show calculating status during a long calculation. I have checked all the options, turned status bar on/off, uninstalled Excel, reinstalled Excell, and i'm out of ideas! Anyone have any idea as to why this may be happening? Thanks in advance!!
 
in a vba module type the following:-

sub RestoreStatusBar()
Application.DisplayStatusBar = oldStatusBar
end sub


run this code and you might find the status bar reappears. There might be some code in your startup files that automatically execute on opening excel, this is harmless but can be annoying.

Cheers

Matthew



The only bad question is the question you dont ask!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top