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
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.