Perhaps you inadvertantly unchecked "in cell dropdown"?

If not, see other posts for possibles.

Gord Dibben Excel MVP

On Fri, 17 Dec 2004 08:51:04 -0800, "Ourbriards"
wrote:

I have been using this function for years and now it has stopped working.
The validation setting are all still there, just no in-cell drop down. It
only happens in one worksheet. (of course the one I need it in ;-)