• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

Setting protected cell

  • Thread starter Bruce A. Julseth
  • Start date
B

Bruce A. Julseth

Flightless Bird
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?
 
P

Pegasus [MVP]

Flightless Bird
"Bruce A. Julseth" <bruceaj_nospam@bellsouth.net> said this in news item
news:#6uDSCmjKHA.5608@TK2MSFTNGP05.phx.gbl...
> 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?


Posting in the wrong newsgroup. I would ask the experts in an Excel
newsgroup and mention the version of Excel you run.
 
B

Bruce A. Julseth

Flightless Bird
"Pegasus [MVP]" <news@microsoft.com> wrote in message
news:-OpQBwDmjKHA.1648@TK2MSFTNGP05.phx.gbl...
>
>
> "Bruce A. Julseth" <bruceaj_nospam@bellsouth.net> said this in news item
> news:#6uDSCmjKHA.5608@TK2MSFTNGP05.phx.gbl...
>> 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?

>
> Posting in the wrong newsgroup. I would ask the experts in an Excel
> newsgroup and mention the version of Excel you run.


Yah. Sorry..
 
Top