Unprotect - execute macro - protect

[paesu57]

Hi all
I've been searching for code to unprotect my workbook, run the code and then reprotect it. I have found simple solutions like

ThisWorkbook.Unprotect Password:="accounts_2014"

My Code

ThisWorkbook.Protect Password:="accounts_2014"


But somehow it does not work and provides a runtime error.
Can anyone help?

[TMS]

It may be that you need to protect the worksheet(s) rather than the workbook.

I suggest you post a sample workbook with the code.

Regards, TMS