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