Worksheet.Unprotect - Office Interop - Difference between 2003 and 2007
- by sdmcnitt
I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect
1) that the protection is turned off
2) that the password is removed (protected but there is no password)
3) that the password matches the correct password from a database
To meet the second requirement the program calls…