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