how to validation by list is made by macro
when sheet 1 is active then cell "D3" create validation by list with macro and list is create in sheet 2 cell range "A1:A100"
and also it is possible when i click on button then validation is clear.
You can record Your macro as You need
and use it as You want with 'when sheet1 is active'.
Also You should make 'on button' to clear validation (fromsomewhere hmm?)
