Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking for viewing (in VBE)
Assuming all my passwords are "abc"
To unprotect my active sheet, I do ActiveSheet.Unprotect abc To unprotect my write protected workbook, I do Workbooks.Open Filename:=TargetPathAndName, WriteResPassword:= abc But to unlock for viewing in VBE, my module1 under Project Name Book, what the code like? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlocking for viewing (in VBE)
It can be done, but it involves the use of SendKeys which isn't too stable.
This is an example, but you may need to tune it 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" .SendKeys "~", True ' Enter End With -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Edmund" wrote in message ... Assuming all my passwords are "abc" To unprotect my active sheet, I do.. ActiveSheet.Unprotect "abc" To unprotect my write protected workbook, I do.. Workbooks.Open Filename:=TargetPathAndName, WriteResPassword:= "abc" But to "unlock for viewing" in VBE, my module1 under Project Name Book, what the code like? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unlocking a Workbook | Excel Discussion (Misc queries) | |||
unlocking a row | Excel Discussion (Misc queries) | |||
Unlocking cells | Excel Discussion (Misc queries) | |||
Locking and unlocking a Excel project for viewing | Excel Programming | |||
Unlocking in 97 | Excel Programming |