Change your macro to unprotect, run the routine then re-protect.

Sub runit()

ActiveSheet.Unprotect Password:="justme"

your code runs here

ActiveSheet.Protect Password:="justme"

End Sub


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 12:08:04 -0700, ub wrote:

Yes, it does alter the locked cells

"Terry" wrote:

is the macro altering any of the locked cells on the protected sheet ?

"ub" wrote:

Hi
I am protecting a sheet that has macro, my sheet fives macro error.
But when I unprotect the sheet and run the sheet, there is no error.
Please advise.