Circular Ref Indicator Missing

K

kcc

I just noticed that on my computer at work, if there is a
circular reference I get the usual dialog box, but I don't get
message in the status bar. At home using the same
version (Office XP) I do get the status bar message.
The calc options and every thing else I can find seem to
be set the same between the 2 copies, but the one at work
is an enterprise install which may be different from the
standard single license version I have at home.
Is there any settings I'm missing that would cause this?
kcc
 
D

Dave Peterson

Could you have run a macro that took over the statusbar and didn't give it back
when it was done.

If I put this in a macro:
Application.StatusBar = ""

Then never reset that statusbar, then none of excel's messages showed up.

You could try this:

hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

Type this and hit enter:
Application.StatusBar = False

Then close that window and back to excel to see what the statusbar looks like.

You should see the word Ready at least.
 
K

kcc

Thanks, I'll try this when I'm back at work in the morning.
It's highly likely your suspicions are correct as my employer
installed add-in software that audits spreadsheets.
It screws up excel in many other ways so I should have thought
of it for this also.
 
Top