Setting protected cell

  • Thread starter Bruce A. Julseth
  • Start date
B

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

Pegasus [MVP]

Bruce A. Julseth said:
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?
Click to expand...

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

Pegasus said:
Posting in the wrong newsgroup. I would ask the experts in an Excel
newsgroup and mention the version of Excel you run.
Click to expand...

Yah. Sorry..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Cell Problems 2
Excel VBA 1
Using Worksheet_change module in protected workbook. 3
cell validation on protected sheets 2
BeforeDoubleClick on Protected Sheet 2
Run-time Error '1004' 1
Macro Runtime errors 8
How change unprotected cell formats on protected worksheets? 2

Top