Jim

As you say, the trick is to copy all the sheets at once.
--

XL2003
Regards

William



"JK" wrote in message news:xPqce.15$eC.13@trnddc07...
Thank you William

I tried that but get link back to the book I'm copying from. Perhaps the
trick is to copy all sheets at once?

Jim Kobzeff

"William" wrote in message
...
Hi Jim

Unhide any hidden sheet in the current workbook.
Select all the sheets, right click on one of the sheet tabs and select
"Move or Copy".
Place a check mark against "Copy".
Select the destination workbook from the dropdown list and that should do
it.
--

XL2003
Regards

William



"JK" wrote in message news:wYece.19162$yc.11755@trnddc07...
I was told that it is a good idea to create a new WB for an excel
application that has been in revision for 3-4 years. Seemingly, it clears
out any bugs that might have developed after countless changes, etc.
Moving forms and modules is easy, but how can I copy the sheets to the
new workbook without my formulas making a reference to the old workbook.
Example: the formulas in my HideAll sheet (where most calculations take
place) end up like =[old.xls]Sheet1!$A$1 instead of =Sheet1!$A$1. This
one should be easy, but it's driving me crazy because I can't figure it
out. Please help. Thank you.

Jim Kobzeff