Hi There,

I would like to trigger a maco when the nr of sheets in the active
workbook changes ...

Not: Private Sub Workbook_NewSheet(ByVal Sh As Object)

As this triggers only when a New ("Blank") Sheet is inserted.
But it should fire as well when I make a copy of an existing sheet(s).

Please?

Best Regards, Sige