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

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

also, if the links are only between the sheets copied, then if you group the
sheet and copy them all at once, the links will not reference the source
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