I have decided to use sort of a back door method. I am going to make that
cell a formula equal to a value in another sheet that is unprotected.
--
Thanks
Shawn


"Shawn" wrote:


Sub go()
Dim goal As Range
Set goal = Sheets("sheet1").Range("A1")

Range("A1") = goal + 1
End Sub

I get an error because this is on a protected sheet and protected cell. How
can I get result without having to unprotect the sheet?


--
Thanks
Shawn