I have a workbook, with a bunch of VBA code that refreshes the data in the
Auto_Open event. Once opened, I would like for the end user to be able to
save an archived copy of all of the data, spreadsheets and graphs in the
workbook, but with all the VBA code removed.

Whatever method is used, I would also need to make sure they don't overwrite
the original spreadsheet as well.

Any ideas? Thanks!