After running this macro a dynamic range stops working. How to fix?

Hi. Any guess on why this macro is blocking the worksheet selectionchange macros after been triggered?

Thank you

Please Login or Register  to view this content.

Also those macros are blocking the selectionchange when triggered

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Suggest you post a sample workbook with some typical data and all your code.

So... I've reproduced what is happening in this attached file.
I have no clue.
I know if I change the position of the enable events to true right AFTER End If... the problem doesn't occur but the macro takes too long to perform. So that's not the solution.

ps Sheet2 has a macro inside.
PS Also if you push SAVE NEW RECORD will cause the bug mentioned in the sample...

Thank you

One minor issue:

Please Login or Register  to view this content.

The code highlighted in red is, effectively, a cell selection change ... which will fire the Worksheet_SelectionChange. The code shown in blue demonstrates the impact of that selection change.

Please Login or Register  to view this content.

However, the real issue, AFAICS is this:

Please Login or Register  to view this content.

Here, the code in red exits the subroutine without executing the code highlighted in blue.

Change the code to this:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.