Protected Cell Problems

[Bruce A. Julseth]

I have protection turned on and now cannot write to a protected cell with my
VBA code..

DateCompleted = Now()

The cell addressed by DateCompleted works fine when the sheet is
unprotected.

When I run protected I get

Run-time Error '1004'
Application-defined or object-defined error

The Cell does have conditional formating

What am I doing wrong?

 

[Gary Keramidas]

maybe you need to use something like the following:

Worksheets("Sheet1").Protect userinterfaceonly:=True

 

[Bruce A. Julseth]

That seems to work. Thanks..

Bruce

maybe you need to use something like the following:

Worksheets("Sheet1").Protect userinterfaceonly:=True

--


Gary Keramidas
Excel 2003