| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot remove password from file
I have a file that has a password. I enter the file and then SaveAs.. and
blank out the password and save the file. When I reopen the file it still asks me for the password. Why is this? Thank you, Steven |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot remove password from file
You can't just blank out the password from the code and make it go away. You
have to unprotect the worksheet or workbook. ThisWorkbook.Unprotect "password" or ActiveSheet.Unprotect "password" Then save the file, close and re-open. It should not ask for the password. "Steven" wrote: I have a file that has a password. I enter the file and then SaveAs.. and blank out the password and save the file. When I reopen the file it still asks me for the password. Why is this? Thank you, Steven |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Password | Excel Worksheet Functions | |||
| PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
| Remove or change password protected excel file | Excel Discussion (Misc queries) | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Linear Mode
