Tom,

Success! Still am not sure what the culprit was, but found this
Started dummy code and typed 'application' and as soon as I entered
the '.' the autolist appeared. Any thoughts?
It wasn't working with other objects, but now is...

Also found a Temp folder (I had overlooked) and it was stuffed.
Cleared it out (after the above).

Its still a mystery - but fixed (for now).

Your advice helped... Thanks!

--
sb
"Tom Ogilvy" wrote in message
...
If you want to find the cause, then I think you will have to retrace your
steps and find out what changed during the period when the lists stopped
showing up. This would be useful in any event, because unintalling
Office
doesn't necessarily clear out everything, so you could have some residual
environment stuff left (which could be the culprit).

--
Regards,
Tom Ogilvy




"steve" wrote in message
...
Tom,

Followed your instruction. And no luck. Guess I'll have to reload.

But a thought - recently had 97 and 2k loaded (in different folders) on
my
machine and they were both doing OK. Now neither shows the autolist.
Do you think that the problem might be there???

Be aware that
Option Explicit is Always on
Variables are declared
All temp folders and recycle bin are cleaned at least once a day
(sometimes more) (my Internet Temp fills up fast).
All Options are checked. Tried unchecking and rechecking to make
sure.
I do get the Auto Quick tips!!!

Did the 'run' thing both before and after I rebooted.

Sure miss that list!!!

Thanks for your help and patience!!!
--
sb
"Tom Ogilvy" wrote in message
...
It is called autolist members under the tools=Options menu in code
settings. You say all these are checked and you say you always use
option
explicit, so your objects are declared. I can't say what is causing
the
problem. Perhaps close excel, clean out your temp directories and
reboot.
You may have to reinstall office <g. But I would next try to
reregister
by
going to the run option under the start menu and do

excel.exe /unregserver
then again with
excel.exe /regserver

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
Your assistance please...

Usually when writing code a drop down would appear after adding "."
like Activecell.
but suddenly it is not there. (sorry I don't remember what it is
called)

Can anyone steer me in the right direction as to fix this.

It has happened with both Excel97 & Excel 2k on my machine.

I checked the Tools Options and all the Code Settings are checked.

thanks in advance...

--
sb