copy and paste sheets

is there a way to copy and paste sheets into another workbook without copying the macros that are in those sheets. I have macro that basically selects 10 sheets from one workbook and copies and pastes those sheets in another new workbook.

Until now it was no problem because there were no macros on those sheets, but now I had to include a macro for one of the sheets, but I don't want that copied when I run my "copy" macro. I just want the sheet. Any ideas?

Originally Posted by Mordred

In your code when you paste try:

Please Login or Register  to view this content.

I don't know if that would apply what your code is doing but just pasting the values should do it I think.

Yes, that line is already in my code. So when the sheets are pasted into a new workbook there are no formulas, just values. That's not really my problem, the problem is there can code attached to the sheet. Ever open VB and double click on one of the sheets in your workbook, it's probably blank for you, well you can assign code to that sheet so whenever a user clicks that sheet from another sheet the code is executed. I don't want that code copied over into a new workbook.

Originally Posted by Mordred

Sorry I can't help on that one. I just made a mock book with a straight copy from a workbook where there is code specifically in a worksheet and didn't have the code go with it. All of the values went from the excel sheet but no code.

How did you do it? did you right click the worksheet and click "move or copy" and then select "(new book)" and then clicked "create a copy" box and then clicked "OK"?

First, right click the sheet and click "View Code", is there code there?
Then do the above
Then right click the new sheet in the new workbook and click "View Code". Is the code there from the original?

I just did it without running my macro and yes it is still there.