How to copy entire workbook?

[ninjamyst]

What are the ways to copy an entire workbook to a new workbook? I am thinking of copying all the worksheets but that's tedious. Is there a simpler way?

 

[SkipVought]

How about SaveAs?

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[KenWright]

In Windows Explorer, just right click, copy and paste.

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[KenWright]

And if you just want all the worksheets into a new book that already contains other worksheets, then select all worksheets together, right click on any tab, choose 'Move or Copy', tick ' make a copy and select the new workbook to copy to from the dropdown menu. When done, If you had any links in your sheets to other sheets in that book then you may have just created external links back to the original workbook. If so, then choose edit / Links and then change source and then point any links to the new workbook at which point the links will disappear.

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------