Changing the value of a protected cell
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
|