Copying entire sheet to a new workbook (and ignoring macros used for that sheet)

I'm trying to copy a sheet to a new workbook and save it by using a macro. I found this code (http://www.vbaexpress.com/kb/getarticle.php?kb_id=359) which works all and well, except when it runs into a sheet that uses a macro (a button or a cell selection change).

Basically, I need to copy paste all the values without pasting any macros used (in order to upload the document correctly, it is required to not have any VBA within it).

Does anyone know how to do this?

Thanks

When you copy a worksheet and paste into another, the macros in the first aren't included. Is it possible that you're talking about copying the VALUES in the first, and pasting them into the second without the formulas?

So in sheet 1 you have in cell A1
= 1+2 (displaying "3")

You want to transfer only the "3" to the new workbook?

If so, can you not copy the entire sheet and use paste special in the new one?