Thread: Copy worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Copy worksheets

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/