Using TimeBombMakeReadOnly gives run-time error?

**e.good** · 02-19-2011, 09:56 AM

I am using Chip Pearson's code for setting a timebomb. However I am getting a run-time error '1004' Application-defined or object-defined error when the ExpirationDate is set on the second line of execution. Shouldn't this run as is or am I missing something here? I don't get why the error isn't handled with the "On Error" code ...

Please Login or Register  to view this content.

**shg** · 02-19-2011, 10:05 AM

You must have a defined name ExpirationDate that contains the date.

**e.good** · 02-19-2011, 06:10 PM

It seems that this code was written to accommodate the pre-existing definition of the name (hence the On Error Resume Next handling). Testing this routine in a brand new workbook causes the same error, so I don't see how this can be the problem.