The workbook that I am using in Excel has some protected cells. I am not able to unlock them. I need to transfer data from one column that is locked, to another column that is also locked. I can do this manually by typing in the data, but the workbook will not allow me to copy/paste (either using VBA or the normal way) the data in the protected column. Below are examples of the code that I've tried, without any luck.
Is this even possible without unlocking the workbook?
Example 1:
Sub Requote()
Dim JDsheet As Worksheet
Set JDsheet = ActiveWorkbook.ActiveSheet
JDsheet.Range("Q26:R41").Copy JDsheet.Range("S26:T41")
Example 2:
Sub Requote()
Dim JDsheet As Worksheet
Set JDsheet = ActiveWorkbook.ActiveSheet
JDsheet.Range("Q26:R41") = JDsheet.Range("S26:T41").Values
Note: The columns I am working with are made up of merged cells.
Edit: A comment from @Raystafarian led me to a post here which allowed me to unlock the protected sheet.
I will leave the question open for anyone who has a solution other than a hack on the protected workbook.