View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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