It might be able to be done, but you'd have to expand your details.

But excel has a nice built in way of choosing from a list.

You can use Data|Validation to choose from a list.
http://www.contextures.com/xlDataVal01.html

And if that list grows and contracts, you can use a dynamic range name.
http://www.contextures.com/xlNames01.html#Dynamic

Both of these are from Debra Dalgleish's site.

hedonist68 wrote:

I'm trying to set up a workbook that allows users to select the names of
staff using option buttons. There is a seperate sheet for each day of the
week with the same option buttons on each page. Is it possible to have a
setup page where the names of the staff get inpput by the user, and then have
the caption for each of the buttons linked to the appropriate cell on the
setup page?

--

Dave Peterson