Prompt to Enter Workbook Password When Opening File

[masouder]

I have code that opens all workbooks in a folder using the Open method. Several of the workbooks have links to another spreadsheet that is password protected. As each file opens the user is prompted for the password for the linked spreadsheet. Is there any way that I can prevent the password prompt? I played around with the

Application.AskToUpdateLinks

setting but that did not work. Neither did

Application.DisplayAlerts

.

Any ideas are appreciated,

 

[Joe4]

Password protection wouldn't be worth very much if there was a way to easily override or ignore it! It is there for a reason!
Otherwise, you would have come up with a real simple way to get data out of a password protected worksheet without actually having the password (rendering the protection relatively worthless).

If you want to ignore that prompt, then have VBA supply the password when opening the file:

Workbooks.Open Filename:="...\SomeFileName.xlsm", Password:="1234"

 

[masouder]

Password protection wouldn't be worth very much if there was a way to easily override or ignore it! It is there for a reason!
Otherwise, you would have come up with a real simple way to get data out of a password protected worksheet without actually having the password (rendering the protection relatively worthless).

If you want to ignore that prompt, then have VBA supply the password when opening the file:

Workbooks.Open Filename:="...\SomeFileName.xlsm", Password:="1234"

Thanks for the reply. I fully agree that we don't want to circumvent passwords. I was hoping for a way to not update links programmatically so that the file with the password would not be accessed and, therefore, remove the need for a password.

With regard to the suggestion to provide the password, how would this work? The code is opening File1 which has links to File2, and File2 is the one that is password protected. Is there a way to open File1 and provide a password for File2?

 

[masouder]

Thanks for the reply. I fully agree that we don't want to circumvent passwords. I was hoping for a way to not update links programmatically so that the file with the password would not be accessed and, therefore, remove the need for a password.

With regard to the suggestion to provide the password, how would this work? The code is opening File1 which has links to File2, and File2 is the one that is password protected. Is there a way to open File1 and provide a password for File2?

Actually, I think I figured out a solution: open File2 first, providing the password, then open File1. As File2 will already be open there will be no need for File1 to try to open it.

I hope that works.