Is this drop down a control or is it in a cell?

I'll tackle the drop-down-in-a-cell possibility, and if it turns out to be a
control, the discussion will continue <g.

If it is in a cell, then the cell is using Data Validation. Click the cell
and go to Data -- Validation and you'll see the dialog used to set up the
list. There is an area with the "Source" label associated with it. The
names may simply be typed into that area, separated by commas. You could
edit the list directly in that list.

But the "Source" could be a formula such as =MyNamesList and MyNamesList
will be a named range in your workbook referring to a range of cells
somewhere with the list in it. That list could be on another sheet, and that
sheet could even be hidden from view. You can find out where that list is by
using Insert -- Name -- Define and picking it from the list and you'll see
it's location in the "Refers To" section.

Finally, if none of the above yield any results, or if you change the list
and it changes back to its original contents, then it is probably defined in
a macro that runs when either the workbook is opened or that worksheet is
selected. You'll have to look in the workbook's code to find where it is set
up ata.

"Dave" wrote:

Hi

I have a spreadsheet that when you open it a drop down list shows a choice
of names to choose from that each relate to an individual sheet. How do I
access this drop down list to edit the names?

Thanks