Is it possible to open the encrypted file via vba macro? I encrypted the file with password :MY_PWD and I've to open same file. I tried with ActiveWorkbook.unprotect Password:="My_PWD" in workbook open() event. even if the macro is enabled it asks me to enter the password. can we bypass that problem? wont it take the password from the code or how can we give the password via VBA?

BR
P Sukumaran