I think I must be doing something very stupidly word, but trying to create a Macro to save me having to type in password protected passwords into my master spreadsheet. I have the passwords - so not looking to crack them, just open them without having to type in the passwords.
Currently only 2 workbooks are protected - however over the next month this will increase to 18 (hence me wanting to create this macro!).
So I am starting with just one workbook at present - however my VBA knowledge in limited (so apologies in advance!)
I have tried many codes - but was told this would suffice:
Open to any suggestions.