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?

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?