Is it possible to programmatically unlock a password protected project
for viewing?
TIA
Paul
Unlocking a VBA Project with this sample worked for me; this was run from a
command button from another workbook in one Excel instance so it will
probably have to be customized.
Sub UnlockVBAProject()
' XL2000, Win2K
With Application
.SendKeys "%{F11}", True ' VBE
.SendKeys "^r", True ' Set focus to Explorer
.SendKeys "{TAB}", True ' Tab to locked project
.SendKeys "~", True ' Enter
.SendKeys "password" ' project password
.SendKeys "~", True ' Enter
End With
End Sub
"Paul Sardella" <PSar...@cheerful.com> wrote in message
news:3B1D7A4F...@cheerful.com...
No.