can i search on headersName and lock the entire column of a particaular Header

Start by unlocking all the cells in your sheet and then protecting the sheet. This macro will prompt you to enter the column header name and then that column will be locked.

Please Login or Register  to view this content.

thanks but it locking whole sheet

but i want to specify multiple columns names in the code itself

If you place the column names in the code, the same columns will be locked each time you run the macro. Is this what you want or will the columns change each time? If you want to lock the same columns each time, I would need to know what those columns are. It would be easier to help if you could attach a copy of your file with a detailed explanation of what you want to. When I tried the code on a dummy sheet, it worked properly.

Please have a look at the attached file. Because the columns you want to lock constantly change, there needs to be a way to choose which columns you want to lock each time. You'll notice on Sheet2 that there are three buttons. Clicking the 'Copy Column Headers' button will copy the column headers from Sheet1 to column A of Sheet2. Once you have done that, put an "x" in column B to mark the columns you want to lock and then click the 'Lock Columns' button. To lock a different set of columns, first click the 'Clear Markers' button and then mark the new set of columns with an "x" and click the 'Lock Columns' button. Remember to start by unlocking all the cells in Sheet1 and then protect the sheet with "password". Hopefully, this work-around will work for you.