| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a worksheet with macro buttons on it
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying a worksheet with macro buttons on it
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying worksheet with macro | Excel Discussion (Misc queries) | |||
| Macro for Copying Worksheet to New Workbook | Excel Discussion (Misc queries) | |||
| Worksheet Buttons disappear after Macro runs! | Excel Programming | |||
| Copying Data into another worksheet using macro | Excel Programming | |||
| Copy Sheets minus Worksheet Change Event code & Macro Buttons | Excel Programming | |||
Linear Mode
