Hi

Your macro can unprotect the sheet, do what you need and protect the
sheet again.

Sub Test()
Sheeets("Sheet1
With Sheets("Sheet1")
.Unprotect Password:="JustMe"
.Range("A1").AddComment ("Merry Christmas")
.Range("B1")="Hello"
.Protect Password:="JustMe"
End With
End Sub

Hopes this helps.
.....
Per


On 8 Dec., 02:09, Keyrookie wrote:
How can you have your macros run in a protected sheet? *Also, I need to
be able to insert comments. *Any ideas anyone?

K

--
Keyrookie