To modify a template in Excel

Need:
1. Change the details and leave only one instead of the drop-down list
2. To see what macros are falling and fix them.
3. If possible, to make sure that they do not fall (macros).
4. To make changes to a dropdown list di