On our training machines, autofilter no longer gives the number of records on
the bottom left, it now say READY, I know that Filter mode shows sometimes,
what's changed on the laptops?

Thanks

Diane

Try,

Right click the bar (by ready) and select what you want displayed.

Mike

"DianeG" wrote:

On our training machines, autofilter no longer gives the number of records on
the bottom left, it now say READY, I know that Filter mode shows sometimes,
what's changed on the laptops?

Thanks

Diane

Sorry Mike,

That's not quite what I was looking for, it should display for example "4
records of 16"

Thanks

diane



"Mike H" wrote:

Try,

Right click the bar (by ready) and select what you want displayed.

Mike

"DianeG" wrote:

On our training machines, autofilter no longer gives the number of records on
the bottom left, it now say READY, I know that Filter mode shows sometimes,
what's changed on the laptops?

Thanks

Diane

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane

Thanks Roger but that it didn't mention it either, it's a real mystery
because we've always got a total before, now it's stuck on READY.

"Roger Govier" wrote:

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane

Hi

Then from a previous post of Nick Hodge

Opening the VBE (Alt+F11) and if there is not an immediate window
showing,
go to ViewImmediate 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)


You could try this to see if it helps.

--
Regards

Roger Govier


"DianeG" wrote in message
...
Thanks Roger but that it didn't mention it either, it's a real mystery
because we've always got a total before, now it's stuck on READY.

"Roger Govier" wrote:

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane

Thanks a lot for that, I don't know much about VBA but it will be interesting
to give it a go

Regards

Diane

"Roger Govier" wrote:

Hi

Then from a previous post of Nick Hodge

Opening the VBE (Alt+F11) and if there is not an immediate window
showing,
go to ViewImmediate 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)


You could try this to see if it helps.

--
Regards

Roger Govier


"DianeG" wrote in message
...
Thanks Roger but that it didn't mention it either, it's a real mystery
because we've always got a total before, now it's stuck on READY.

"Roger Govier" wrote:

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane