Stop Worksheet change event from interfering with macro code

Hi everyone,

I have a worksheet event that seems to be interfering with the functionality of a macro.

The macro is used for adding a specific number of new records based on the number value of a cell on the worksheet. Without the worksheet event code in place, the add record macro functions flawlessly. With it, no matter how many records are selected to be created, only one is created.

The worksheet even watches a specific cell on each row and locks and unlocks cells in the same row when the value of the watched cell changes based on 5 different possible settings. Other than it interefering with the macro functionality, it too works flawlessly otherwise.

I've been trying everything I can think of but I can't get the two to play nice together. The worksheet event code and the macro code are below. Can anyone tell me why this is happening and what I can do to fix it?

Thanks, very much!

Worksheet Event Code

Please Login or Register  to view this content.

Macro Code

Please Login or Register  to view this content.

Cytop, thanks very much! That did the trick. Still learning so didn't know about the Application.EnableEvents property. Great tip!

It works beautifully now.