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