View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce A. Julseth[_2_] Bruce A. Julseth[_2_] is offline
external usenet poster
 
Posts: 29
Default Protected Cell Problems

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?