Need more information on what you are trying to do…. Do you want the sheet not to copy over if it already exists in book you are copying it to or do you want it to rename to a different name? Is there certain sheet that you never want to copy over? Is the Sheets stored in currently opened file or in a different file? Is the file it is copying the data to always going to be the same name stored in the same spot?
The disabling of the Save is the easy part! You Can remove he MsgBox line if you don't wish forth message to show up every time someone try's to save.
In This workbook place the following code
Bookmarks