i DO WANT TO FORCE THE USERES TO PROVIDE THE RESPONCE(THERE NAME FROM A LIST)
and record it on a worksheet

"Alok" wrote:

This can be done without programming.
In Cell A1 create a DataValidation List with all the names. Then after the
workbook opens the user selects his/her name from that list.
If you want to force the user to provide a response then you have to use a
form and a list box.

Alok Joshi

"Glenn" wrote:


I am intrested in learning the following:

When a person clicks to open an excel file I would like for that person to
be able to select their name from a list and have that name entered
automatically onto the worksheet that is opening.

I am a pretty much a novice at this.
THANKS guys for your help!
Glenn