Replied 8 September 2017, 12:52 pm EST
For the Excel file I sent you, I did not turn on the Protect Sheet, otherwise it would have been exactly what I have described. It does not seem to affect the sample project however. You can turn the Protect Sheet on before you import it, just to be consistent with what I said earlier.
The only macro that runs when the Excel file is in operation is the Worksheet_Change event for sheet1. This sub converts the text dropdown to a numeric value based on the lookup tables on the Codes sheet.
The other macros would have been executed from within another vb.net export program when the data in the Excel file are populated. So by the time one opens up the Excel file, these macro have already been run. They are mostly for moving data from sheet to sheet, setting up Data Validation (text or numeric dropdowns), setting cell range lock and formatting.
Only the cells with a gray backcolor are set with lock formatting. So the PropName column, for example, is not locked. Had I turned on the Protect Sheet, the grayed out cells will be Read-Only, while the rest will be updable. So there is nothing special for a column like the PropName.
Hope I answer all your questions regarding the Excel file.