Break points not working

I have a spreadsheet that I have been using for some time.
Suddenly, in just the Worksheet_change event procedure, break points will not work.
In the same sheet break points do work for other events.
I've tried everything.
Can anyone help?

DesM

Thanks for reply.
Yes, the break point works on other events (doubleClick and selectionChange) on the same sheet. And these call macros.
The event itself is firing because I have put Msgbox in several places and it comes up.
A funny thing too: the event is meant to call a macro but it is not (and it did a week ago). I made up a new macro (just to show MsgBox) and called it and this works. The macros are on different module sheets.
I've tried making a copy of the sheet, deleting the code in it's module sheet, and then repasting it in from Notepad. No difference.
I also tried a Code Cleaner.
Hope you can help.

DesM

Thanks, here is the workbook.
The Input sheet is the one to focus on.
When you select a cell in the B column, it offers you a dropdown. When you select, this triggers a change event which should trigger the CopyFormula macro (which copies formulea from the Transactions Range to the active row).
Regards,
DesM

Andy, thanks for input.
Forgive my ignorance, but what is "DV"?
Is there a solution? (maybe when I know what DV is I will be obvious).

DesM

I'm very puzzled. Please have a look at the attached workbook - it works fine!
Also, my accounts workbook worked fine up until this week.

DesM

Andy, I've just opened a version I saved two weeks ago and everything works fine.
Do you think, given my limited VBA capability, that I would be better rebuilding the changes I made since then into this, rather than trying to persevere with finding the problem in the modified version?
Help appreciated.
DesM

Thanks Andy for advice.

DesM

I know this is an old thread, but in case somebody else finds it here's the solution I discovered (almost certainly not the same problem as in the OP).

I had the problem with breakpoints not stopping the code. I was additionally confused because even if I edited the code, the macro would execute as if the code had not been edited. This was easy to see because I was deleting columns in the table and could not get it to change which columns were deleted.

The problem was that the changes I made (including adding breakpoints) were not recognized while I had the Find/Replace popup open. As soon as I closed that little window everything worked as expected. Strange bug.

Originally Posted by dphb

I know this is an old thread, but in case somebody else finds it here's the solution I discovered (almost certainly not the same problem as in the OP).

I had the problem with breakpoints not stopping the code. I was additionally confused because even if I edited the code, the macro would execute as if the code had not been edited. This was easy to see because I was deleting columns in the table and could not get it to change which columns were deleted.

The problem was that the changes I made (including adding breakpoints) were not recognized while I had the Find/Replace popup open. As soon as I closed that little window everything worked as expected. Strange bug.

Did you ever come up with the fix? I am having the same problem. Changes to the code are not being recognized. Breakpoints are not working. I have restarted computer but did not fix. Hopefully you can shed some light.

Originally Posted by biocentrism

Did you ever come up with the fix? I am having the same problem. Changes to the code are not being recognized. Breakpoints are not working. I have restarted computer but did not fix. Hopefully you can shed some light.

actually i just fixed it. seems the module is corrupted.

SOLUTION: create a new blank module. copy paste the code from the old module to this new blank module. delete the old module!

Originally Posted by biocentrism

Did you ever come up with the fix? I am having the same problem. Changes to the code are not being recognized. Breakpoints are not working. I have restarted computer but did not fix. Hopefully you can shed some light.

My problem was that Excel's Find/Replace window was open. I'm afraid I don't have more insight than that.