Hi
see:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


Geoff D'Arcy wrote:
I need some help with a workbookI am making. I am fairly capable of
most excel uses, however I am working from someone else's sheet which
has a lot of protected cells and I would like to simply make my own
that looks the same. But I like how he did his "drop down menu" to
change the date, so I need to know how to go about doing that? Would
someone have the time to look over this file and give me an idea how
I can recreate this? Thanks.

Geoff