PDA

View Full Version : Solved: Copy Range Names



tqm1
06-20-2007, 04:42 AM
Dear Experts

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

Please help

Bob Phillips
06-20-2007, 04:47 AM
Copy the sheets that the names refer to over to the new book, and the names will go with them.

tqm1
06-20-2007, 05:01 AM
Dear Sir,


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

Please help

Bob Phillips
06-20-2007, 05:41 AM
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.