LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with IRM protected files created before 18/11/09 gwaxiom Excel Discussion (Misc queries) 0 November 21st 09 09:30 PM
1004 Cell Protected Error for data validation lists when locked and protected [email protected] Excel Programming 2 November 7th 06 10:07 AM
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly [email protected] Excel Programming 2 June 6th 06 04:15 PM
Problems on Protected Sheet Frederick Chow Excel Programming 2 January 4th 06 04:00 AM
problems w solution 4 enable AutoFilter for a protected worksheet sharona Excel Programming 1 October 13th 05 04:59 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"