Bypassing password entry

[Iain McBride]

Hi,
I have a master documents that takes data off approximately 20 other workbooks, however some of these workbooks are password protected.
Is there was way (coding or macros) that entering the passwords can be stopped - as its a pain having to click several boxes to either input (or not) the password.

Thanks
Iain

 

[Roderick_E]

maybe

application.displayalerts = false
'rest of your macro here
application.displayalerts = true

 

[Macropod]

Presumably, your code is opening the workbooks concerned or accessing their data via ADODB; in that case modify your code to supply the required passwords. Disabling alerts won't help you to access the data when a password is required.

Roderick E: Your post implies a method of bypassing Excel's security. Kindly read Rule 6: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[Iain McBride]

Thanks for your help. I'll look into those aspects and try and insert coding for the passwords to negate the need for a password to be entered.
Cheers
Iain

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1246055-bypassing-password-entry.html#post4976733

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Iain McBride]

Thanks Fluff - but there was not mention of the post on Excel forum as only did that an hour or so ago

 

[Macropod]

I note there is a fundamental difference between your problem descriptions here and at ExcelForum. There you refer to "several other worksheets"; here you refer to "approximately 20 other workbooks". Any solution will depend on using code applicable to the situation you're actually dealing with.

 

[Iain McBride]

Fair answer Macropod - currently there are about 9 workbooks linked to the master spreadsheet but as our workers go back into schools I envisage there being about 20 linked workbooks in the upcoming month.

 

[Macropod]

Now also cross-posted at: http://www.vbaexpress.com/forum/showthread.php?63683-VBA-novice-needing-help!!
Kindly read -and abide by - MrExcel's rules on cross-posting, as previously requested.

 

[Macropod]

Now also cross-posted at: https://www.ozgrid.com/forum/forum/...vba-to-input-passwords-from-servant-workbooks