Runtime Error 50290 - HELP I have NO CLUE What to do!

[ladyck3]

Oh HELP!!

I am getting the following Runtime error

Run-time error '50290':
Application-defined or object-defined error

Please see thread 707-1590746 the first snippet of code the following are the first two lines:

Private Sub Worksheet_Calculate()

    If [D3].Value = 1 And [E3].Value = "" Then [E3].Value = Date

This first IF statement is highlighted in yellow as the problem... I do not know how to understand what it is saying. I can click end a few times and get it to go away but what is broken?

This happens each time I make a change on my master update page in a non date field...which is hidden when I'm not updating the workbook..

WHen I make a change in a date field I hit end twice and then get another message

Method "_Evaluate' of objecct'_Worksheet' failed

Then I hit end again and get the Application message twice and then the dialog box goes away.

Users are not having any issues using the workbook but I"m having issues updating it so what have I done wrong and how do I fix it?

This is operation critical








LadyCK3
aka: Laurie

 

[ladyck3]

Update... *I* am the only one having an issue it appears. This is a shared workbook which I unshare to fix, but no one else is having problems.

There was some new security stuff that installed on my PC and it had DRM crap .. stuff in it.... I removed the files and restored my configuration to a previous version but I'm thinking this might be the problem.

In the past this particular security file has caused issues with Excel workbooks.

No need to respond to this sorry to rattle everyone's cage.

Skip... I have not lost track of VBA for Dummies, they've had me extremely too busy to work on it!

Laurie


LadyCK3
aka: Laurie

 

[SkipVought]

OK. Was looking, but not making sence to me.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}