| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unlock for Viewing
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 should I do? Many thanks -- Edmund (Using Excel XP) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unlock formulas and unhide sheets | Excel Worksheet Functions | |||
| Unlock VBA Project | Excel Discussion (Misc queries) | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
| How do I unlock specific cells in a spreadsheet that I protected? | Excel Discussion (Misc queries) | |||
| some keys locked on keyboard. How do I unlock it? | Excel Discussion (Misc queries) | |||
Threaded Mode
