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

Similar Threads

How to enable "Links" when copy a worksheet (with buttons on it) to anew book 2
Excel button problem 2
Copy data using macro (with worksheet protect) 5
Need Macro... 8
How do I set a macro to unhide a worksheet and stay on it? 3
Macro to copy a sheet and delete a macro button 8
Macro to Copy hidden worksheet to new worksheet 4
Code to copy worksheet 5

Top