Maria
I had such an issue some time ago with a huge workbook that i use to my work.
I never learned the reason of the problem but i solved in this way.
I Used 1 simple macro to disable my macros when i wanted to paste anything in this workbook and for beeing sure that everything would be ok after that another one(in workbook open event too) that enable all macros.
For sure is not something perfect but gave me a solution..
Sub DISABLE()
Dim wb As Workbook
Application.EnableEvents = False
End Sub
Sub ENABLE()
Dim wb As Workbook
Application.EnableEvents = True
End Sub
Bookmarks