I have code which needs to be executed when a user copies a worksheet into the workbook where the code exists.
I can include a shape and apply the code/macro to, however how would the reference to the sheet be. The sheets copied into the workbook all have different names.