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

[forth250]

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?

[shg]

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.

[forth250]

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.

[forth250]

Please Login or Register  to view this content.

This also does not seem to work with other workbooks open either, and when I close the other workbooks.

Does anyone have any ideas?

I am working on abit of a deadline at the moment so any help would be much appreciated. Thanks Again

[shg]

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?

[forth250]

Cheers, The new bit of code run when the value in c12 changes. Like the first bit of code it works beautifully, but when I open up certian workbooks at the same time it fails to work. and continues not working even after I close down all other workbooks.


Its definitely nothing to do with the macro that are being called. I have run them mannually and they work fine. The issue is the worksheet change events do not seem to work!

I think it could be some thing do with the data valiadation drop down menu as I was ready about a possible MS bug.


Bit again any help would be much appreciated.

[shg]

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.