VBA Protect only locked cells/columns

[lunatu]

Hi!

I have a macro copying data from sheet1 to sheet2. Sheet2 includes six locked columns (W, AH, AS:AU, AX). Im trying to unprotect the sheet2 columns before running the macro and protect them before ending. Any ideas how to solve this? I have a macro which will protect the whole sheet but obviously it's not working with this

Thanks in advance!

 

[Mr Kulle]

unprotect range vba

Dear All, I am trying to unprotect certain parts of a workbook. I would have thought that the following would work but no luck :- I get "object does not support this property or method":- Invoicing_Tool.Sheets("Job List").Protect 'Big jobs For j = 5 To 19 If...

www.mrexcel.com

 

[lunatu]

Great thanks!

 

[Mr Kulle]

your welcome ^^