Hi,
New here - and a huge Macro novice (so spologises now for my lack of understanding!), however i have a master workbook that reads from 20+ other workbooks.
At present 2 of these workbooks are password protected (likely to increase once our staff input more data) and i wanted to know if there is a coding that would allow me not to have to input the passwords every time i open up the spreadsheet?!
I have all the passwords so not looking to 'crack' anything.
Thanks,
Iain