like i said in the previous post, when you want to make master copies,, disable the events and after you have finished saving the copies re enable them for example:
![]()
Sub SaveCopies() Application.EnableEvents = False ActiveWorkbook.SaveAs "Copy1" ActiveWorkbook.SaveAs "Copy2" ' ' ' Application.EnableEvents = True End Sub
Bookmarks