Help with worksheet password removal

[caman06]

Hi gurus,

I have searched relentlessly and cannot find a solution to my problem

I have an excel workbook with 21 worksheets,

If i run the VBA code for password removal i get the suggestion AAAAAAAAAAA, however this does not remove the protection on any of the sheets.

I have seperated all the sheets into new books and half of them returned the password AAABABABAB which worked, the other half still returning AAAAAAAAAAA but not working to remove protection.

Any Ideas guys?

 

[RoryA]

It is against forum rules to assist with this. Thread closed.