Sheets.copy
Assumes no code in the sheet modules.
--
Regards,
Tom Ogilvy
"courtesio99" wrote in message
...
How can I copy all the worksheets in my current workbook to a new
workbook but I want to remove all the macros in the new workbook?
How can I write a code for it?
---
Message posted from http://www.ExcelForum.com/