I am new to using macros and require some assistance! I have a file that I am trying to collect information. Most cell have a dropdown menu and some are just fill in the information. For the cells that require information (both dropdown and fill-in), I would like them to be locked after information is added to the cells, but only after saving the file, not immediately.
In the excel sheet itself I have locked the cells with headings and other information that I do not want to be changed and have added a password to protect the sheet. ----
Please help if you can!