Copy all sheets to new Workbook

[tqm1]

Dear Experts

How to copy all sheets, including VBA source codes, to new workbook.

Please help

[lucas]

Why not just copy the workbook?

[Pam in TX]

Dear Experts

How to copy all sheets, including VBA source codes, to new workbook.

Please help

Couldn't you just "save as" with new file name?

[tqm1]

Dear Sir,

For some reasons I do not want ot use SAVE AS

I want to copy all sheets into new workbook through VBA Codes

[Aussiebear]

and these reasons are?