VBA code to open new workbook and copy and paste special values

Hi I currently have a workbook with 3 tabs (3 worksheets). One of them is called MTS. Currently, I have a macro that says

Sheets("MTS").Activate
Sheets("MTS").Copy

And then the rest of the macro runs instructions on the new worksheet.

The prob is that I need to paste special formats only to the new workbook so the formulas don't remain active

Does anyone know any VBA code that does this easily?

Thanks so much

How about

Please Login or Register  to view this content.