| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unprotect use 2 passwords possible??
I have a unique scenario where I need to unprotect spreadsheets that I
read in and they all have one of two passwords. Is there a piece of logic that I could use to try one password and if it fails try the second? In other words try password 1 and if it fails try password 2 (without throwing an error on password 1)? Any help greatly appreciated. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unprotect use 2 passwords possible??
Figured it out....on error go to next
Tks! wrote: I have a unique scenario where I need to unprotect spreadsheets that I read in and they all have one of two passwords. Is there a piece of logic that I could use to try one password and if it fails try the second? In other words try password 1 and if it fails try password 2 (without throwing an error on password 1)? Any help greatly appreciated. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unprotect use 2 passwords possible??
Figured it out....on error go to next
Tks! wrote: I have a unique scenario where I need to unprotect spreadsheets that I read in and they all have one of two passwords. Is there a piece of logic that I could use to try one password and if it fails try the second? In other words try password 1 and if it fails try password 2 (without throwing an error on password 1)? Any help greatly appreciated. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Protect OK, Unprotect now messed up! | Excel Worksheet Functions | |||
| Unprotect sheet button!?? | Excel Worksheet Functions | |||
| unable to unprotect my protected excel file | Excel Discussion (Misc queries) | |||
| Random Passwords | Excel Worksheet Functions | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
Linear Mode
