activate list

in sheet 1 i create a list name "item Name" and they contain 50 items
in sheet 2 cell range "A5:A10" list "item Name" is shown by a validation
i want when user activate range "A5:A10" then activate list other wise deactivate

this is only by macro

Re: activate list

i would you attach sample file sheet one list item and sheet 2 create list

when i activate cell A5 in sheet 2 then list activate in cell A5 or when i activate cell A10 then list activate in cell A10.

Re: activate list

no.
only given range will be allow enter value or move cursor by keyboard for edit other range will be not move cursor by keyboard.move cursor by keyboard only given range only