If you are looking only for the data select the full sheet using Ctrl+A and
copy ..New sheet--In A1..Right click..Paste Values.
--
If this post helps click Yes
---------------
Jacob Skaria


"Chris Maddogz" wrote:

Currently I have a worksheet in a workbook with macro buttons on it and want
to make a copy on the worksheet but without the macro button.

Is it possible to copy a worksheet from a workbook but not take across the
macro buttons on the worksheet or am I better just to create a new worksheet
in the new workbook & copy the relevant data?