VBA to unlock cells, run macro then re-lock them

Hi
I have the following code in a worksheet of which Ive locked columns AA & AB, then password protected the worksheet. However when I run my code I keep getting a

Please Login or Register  to view this content.

.
Can anybody help please....I am assuming I need some code to unlock the sheet with the password before unlocking and then re-locking the cells??

Please Login or Register  to view this content.

Thanks in advance

Jen

Hi, Jen,

I am assuming I need some code to unlock the sheet with the password before unlocking and then re-locking the cells??

Either that or protect the sheet on opening the workbook by using the Parameter UserInterfaceOnly:=True which would enable macros to run without unprotecting the sheet. As this is a volatile setting it needs to be done on each opening of the workbook.

Ciao,
Holger