One you copy the sheets, go into Edit=Links, then change the source from
the referenced workbook to that workbook.

--
Regards,
Tom Ogilvy


"Charlie" wrote in message
...
Hi,

I've been handed an old workbook that has been password-protected (VBA
source code). Does anyone know a way to unlock it or get the password?
If
not, I have a previous version that is not locked but some of the sheets
have
been modified. I tried doing a "Move or Copy" of the newer sheets but I
keep
getting formulas that reference the new workbook. Is there a way to get
the
formulas to come across literally?

TIA
Charlie