The code doesn't run on all worksheets. It checks the last worksheet to
see if the date in G8 is within 7 days. If so, it exits, if not, it
copies that sheet and puts the new date in the new sheet's G8.

Where did you "put the code in"? If you put it in the ThisWorkbook code
module, the event macro fires each time the workbook is opened.

In article ,
oberon.black
wrote:

I don't need this code to run on all the worksheets in my workbook. I
only need it for one worksheet.

Plus when I put the code in nothing happened.

Please advise.