Private Sub Worksheet_Change stops working when I have certain workbooks open.

hi,

I have a large model (45 sheets) , with the following code on one of the sheets

Please Login or Register  to view this content.

It works fine at the moment with only that workbook open. However, with other workbooks open at the same open its stops working and it does not start working even after I close the other workbooks.

Does anyone have any ideas?

Welcome to the forum.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

Try this:

Please Login or Register  to view this content.

Thanks - but it does not seem to work.

the "Projects" range is a series of 45 cellls each with drop down menus in them with three options. It works when I close the workbook down and reopen it with no other workbooks open.

You've introduced brand new code. How does this relate to the prior code?

What happens / doesn't happen?

What have you done to debug?

The variable datechange that you declare in the Activate event can't be seen by the code in the Calculate event. If you put Option Explicit at the top of the module, you'll see it doesn't compile.

As to the change event 'not working', I suggest you put a breakpoint in the code to tell you whether the event is indeed firing.