Unlock VBA project or Copy Sheets

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" <Charlie@discussions.microsoft.com> wrote in message
news:8C08F06D-BDBE-4480-9C09-A9178385A48C@microsoft.com...
> 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" <Charlie@discussions.microsoft.com> wrote in message
news:8C08F06D-BDBE-4480-9C09-A9178385A48C@microsoft.com...
> 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
>