saving multiple sheets from workbook.

[JT709]

Hi everyone,

I have a template spreadsheet with seven sheets that are
all linked, when the user has finished filling in the
sheets, I would like them to be able to press a button and
only 3 sheets are copied to a new workbook (but it HAS to be
paste special values as the links have to be removed).
These sheets are password protected,

Any help would be greatly appreciated.

Jon

 

[Legacy 51064]

What are the names of the sheets that you would like to be copied to a new workbook?

 

[JT709]

The sheets name to be copied to new workbook are ("Monthly Sampling Rpt", "Daily Calculation WS" and "WK Avg WS".

Thanks for your help.

Jon