Pop Up Message when User Copies or Creates New Sheet

[christopher.pratt]

I need a macro that will create a popup message any time 1) a new worksheet is created and 2) a worksheet is copied. The contents of the message left aside (use "message" as our example message) could someone help me with a simple code for this?

 

[venkat1926]

there is a small bug in the "sheet copied" event code. the logic of the code is follows
when you copy a sheet for eample sheet1 the copied sheet is named sheet1(2) and that is the active sheet.
I have given a condition that if the active sheet name contains a bracket it will give message box.
suppose you have already copied a sheet and got the message and again somehow activate that sheet in will popup the message.
one way to avoid this when you copy the sheet and the mesage comes up, immediately you change the name for e.g. sheet1(2) into some other name without any bracket.