I am creating an automated tool, but stuck in the selecting whole column while the header is "locked". So the thing is, several first rows dedicated to header cannot be tampered(changed, adding rows, etc) but the others can be changed/added. If I lock the headers and protect the sheet with the "select locked cells" unchecked(so no tampering can be done), the user cannot select the column that they want the data to be processed(the user doesn't want to select the data by himself/herself) because some of the cells will be locked. Is there any way to address this selection issue? Or I should ask in the Excel Programming / VBA / Macros instead?