View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
timatey timatey is offline
external usenet poster
 
Posts: 8
Default Forgotten share & protect password

Hi, Alanso
Recommend you to read an article about excel passwords types
http://www.lastbit.com/excel-article.asp, may be it could help you to
understand the best way how to recover Excel password in your case.
Best regards, Tim.

Hi all.

I am using Excel XP and have forgotten my "Protect & Share Workbook" password.
I have tried JE McGimpsey's and Straxx's password remover, but they dont work.
Does anyone know how to remove this type of password without using a commercial programme?

I've tried adapting the code from JE McGimpsey's site, I.E:
From:
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
To:
With ActiveWorkbook
WinTag = .ProtectSharing
End With


But ProtectSharing isn't a function...

Can anyone please help..
Many thanks in advance.
Alanso.