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?