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

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.