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 |
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 |