How to Solve using CurrentRegion if cells in Table is Protected

[Marsau]

Hi there
If I use CurrentRegion and one or more cells are protected in that range it tells me it can't be used with protected cells.
Anyway to solve this?

[p45cal]

Either:
in the code, unprotect the sheet , do your manipulations, reprotect the sheet.
or:
check out the use of UserInterfaceOnly:=True as one of the arguments of Sheet.Protect; it allows the code to manipulate cells while not allowing the user to do so. Once used, it remains 'in force' until the workbook is closed, so it's a line of code that only needs to be executed once for the sheet some time after the file is opened.

[Marsau]

Thank you for reply
Will make use of protect / unprotect method
Will lookup the other method and give it a try to