Copying a worksheet with macro buttons on it

C

Chris Maddogz

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?
 
J

Jacob Skaria

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top