Hello there, im currently trying to copy and paste a protected cell from one sheet, suppose sheet 1 to a cell in sheet 2. The problem is that i have to retain the protection whilst doing so and apparently when copying the protection is lost. Is there any way of how i can copy and paste the data WITH the protection or any vba code which can be applied to carry out this task?. Thank you.