What about Select and Copy the Worksheet to a New Book instead?

Ron100 wrote:

I copy an excel file each year and update the dates etc to enter a new year's
set of figures. The File Properties still show the original date that the
file was created. How can I amend the creation date to show the current year?