PDA

View Full Version : VBA novice needing help!!



Iain McBride
09-21-2018, 02:07 AM
Good morning everyone, I am new here and in desperate need of some advice.
I know very little about vba etc. so I apologise now for my ignorance!
I have posted a similar question on MrExcel and another similar site but struggling to comprehend hat I need to do... so anyway...

I have a master excel spreadsheet that will (eventually) be fed by almost 20 other workbooks that will be password protected.
How can I write a code on the master spreadsheet that will allow the passwords from the other sheets to be input rather than receive 20 password boxes?!

Thanks in advance
Iain

macropod
09-21-2018, 05:06 AM
Cross-posted at:
https://www.mrexcel.com/forum/excel-questions/1071131-bypassing-password-entry.html
AND:
https://www.excelforum.com/excel-general/1246055-bypassing-password-entry.html


Please read VBA Express' policy on Cross-Posting in rule 3: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3

macropod
10-01-2018, 01:39 PM
Now also cross-posted at: https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1209357-vba-to-input-passwords-from-servant-workbooks

Evidently, you have no regard for this or any other board's rules. Account terminated.