View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Screen / Display "TRUE" "FIX"

Most likely, the "TRUE" in the Status Bar is the result of some badly
written VBA code, which set the status bar text to some informative
text and then used

Application.StatusBar=True
where
Application.StatusBar=False

was really intended, to give control of the Status Bar back to Excel.

The "FIX" indicator means that you are in "Fixed Decimal" mode. In
this mode, input has an implied decimal point, so when you enter 1234
it is treated as 12.34.

To fix both problems, press ALT F11 to open the VBA editor. There,
press CTRL G to display the "Immediate" window or choose "Immediate
Window" from the View menu.

In the Immediate window, type

Application.StatusBar = False

and press ENTER. Then type

Application.FixedDecimal=False

and press ENTER.

Close the VBA editor from the File menu to return to Excel.


Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Wed, 9 Sep 2009 14:26:02 -0700, Sherry
wrote:

At the bottom left of my screen instead of READY, I now show TRUE.
On the bottom right of my screen, I see FIX.

What does this mean and how can I restore the normal?