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

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.


kcc wrote:
>
> 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

--

Dave Peterson

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.

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
> kcc wrote:
>>
>> 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
>
> --
>
> Dave Peterson