Protected Cell Problems
That seems to work. Thanks..
Bruce
"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
maybe you need to use something like the following:
Worksheets("Sheet1").Protect userinterfaceonly:=True
--
Gary Keramidas
Excel 2003
"Bruce A. Julseth" wrote in message
...
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?
|