VBA: Stop the password pop up box from showing
Posted on 2011-09-09
I have a macro that cycles thru a group of files and I'm having difficulty figuring out how to keep the password input box from popping up on the few files in the folder that are password protected. The password input box provides two options. Option 1 is to enter the password and gain access to make changes. Option 2 is to click on the "Read Only" button.
I'm using Excel 2003 at my work.
Any suggestions on how I can suppress the password input box from showing? I've tried intentionally using a blank password in my workbook open statement and then using on error resume next. I still seem to be unable to figure out how to stop the password box from showing.
Any ideas would be appreciated.