Macro doesn't complete when calling from another macro

[DiCaver]

Dear all, hope you are doing fine. I was, but now I have an macro issue ;-)

I have code which insert entire row above active cell, make a copy of previouse row and all cells mark gray, strikethrough... works fine! This is code...

Please Login or Register  to view this content.

But when I call this macro from another code...

Please Login or Register  to view this content.

... everytime first macro stops after "ActiveCell.Offset(1, 0).Select".

Does anyone have any idea why and what to do? Second code is trigered when user select "no" from dropdown menu...


Thx in advance and have a great day, Marko

[Norie]

The first code will probably trigger the Change event, so if you run the first code from the Change event then the Change event will be called again.

Try disabling events before calling the first code.

Please Login or Register  to view this content.

[DiCaver]

Norie... just one sentence: you are real Guru! ;-) Thx!

Cheers, Marko