[COLOR="Blue"]I am trying to pause a macro on a protected sheet, select 2 adjacent cells (initially protected), utilize an existing drop down box to select a name from the list, copy the name from the list into the range of cells, then re-start the macro.
I had no problem when there was just one name (see John Smith below).
I tried to use the InputBox command but needed to actually type in the name.
Any ideas as to how to do what I need?
Thank you all.[/COLOR]