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 ActiveWorkboo
WinTag = .ProtectStructure Or .ProtectWindow
End Wit
To
With ActiveWorkboo
WinTag = .ProtectSharin
End Wit

But ProtectSharing isn't a function..

Can anyone please help.
Many thanks in advance
Alanso.

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.

Alanso wrote in message ...
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?


Hello Alanso,

My advice is to send the file to somebody who knows how to recover
this type of password in MS Excel.

I can reccomend the service on this website, they've never let us
down:

http://www.intertek.org.uk/services/

You can just send them your file, then they email you back the
password. Easy.

Best wishes,

Mark.


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.