Pasting without macros

  • Thread starter Thread starter lynn woolhouse
  • Start date Start date
L

lynn woolhouse

Hi All
Could you help me with this please?
I want to copy a worksheet from a workbook that uses macros, into a new
workbook. I want only the values, but all the macros come along with it. How
can I avoid that.
I hope this is any easy one.
Cheers
Lynn
 
Try:

In the source sheet
-----------------------
Press Ctrl + A
(this selects the entire sheet)
Click Copy

In the target sheet
 
Thanks for your reply Max.
I have already tried this method, without success - all the macros appear
available in the target sheet. I'll try the person who wrote all the macros.
Maybe there's something new here I have not experienced before. If you think
of anything else, please let me know. Regards. Lynn.
 
Do you mean the macro code comes with it or that the objects (buttons?) come
with it?

If you meant the objects and you don't want them, you can use:
Edit|Goto
Special button
Select Objects

And then hit the delete key.
 
Lynn

Sounds like you have some Worksheet_Event code behind your sheet.

I suspect you are copying the worksheet to the new book.

DO NOT copy the Worksheet using the right-click "move or copy" command or the
Edit>Move or Copy Sheet.

Select just the cells using CRTL + A or by hitting the button at top intersect
of rows and columns.

Copy the cells only. The code will not go with them.

Gord Dibben Excel MVP
 
Back
Top