Run-time error 1004 when protecting sheet

I have the following code in place to the current time entered in column G when column D is populated:

Please Login or Register  to view this content.

It works all well and good until I protect any of the cells on the sheet, even ones not included in the macro. I reads, "Run-time error 1004: Unable to set the NumberFormat propert of the Range class. When I click debug, it points to

Please Login or Register  to view this content.

. Anyone know how to correct this?

Any suggestions?

You could manually preset the number formatting of G2:G32 before you protect the sheet. Then just remove the .NumberFormat line in the code. The number formatting shouldn't change.

Alternatively, allow cell formatting when you protect the sheet.

That worked, thanks!