Solved: Copy Range Names

[tqm1]

Dear Experts

How to copy all Range Names from one workbook to anotehr workbook?

Please help

[Bob Phillips]

Copy the sheets that the names refer to over to the new book, and the names will go with them.

[tqm1]

Dear Sir,


and how to copy command button with source codes from one sheet1 to
sheet2

Please help

[Bob Phillips]

Copy the sheets to the new book, and the buttons will go with them, although they will still point to macros in the old book.