Hi,
I frequently lookup to 3 core spreadsheets to check for completion/action dates against task references in my main tracking spreadsheets (we don't have great systems at work, so we are quite reliant on spreadsheets in order to manage tasks, and associated actions)
So when opening, say, my compliance certificate tracker workbook, it asks for the passwords for the 3 Workbooks belonging to my team - which hold the due and order dates for the compliance tasks due on their portfolios.
I have a number of workbooks which always lookg at these 3 workbooks - so it would be really handy if I and my admin didn't have to type the passwords in each time they need to update or check the information (quite frequently).
Is there VBA code that allows you to open the workbook, and at that point of opening the passwords are automatically completed?
I've tried recording a macro but this didn't seem to work. I'm a novice at VBA so simple is good!
Help gratefully received.
Rebecca.
I frequently lookup to 3 core spreadsheets to check for completion/action dates against task references in my main tracking spreadsheets (we don't have great systems at work, so we are quite reliant on spreadsheets in order to manage tasks, and associated actions)
So when opening, say, my compliance certificate tracker workbook, it asks for the passwords for the 3 Workbooks belonging to my team - which hold the due and order dates for the compliance tasks due on their portfolios.
I have a number of workbooks which always lookg at these 3 workbooks - so it would be really handy if I and my admin didn't have to type the passwords in each time they need to update or check the information (quite frequently).
Is there VBA code that allows you to open the workbook, and at that point of opening the passwords are automatically completed?
I've tried recording a macro but this didn't seem to work. I'm a novice at VBA so simple is good!
Help gratefully received.
Rebecca.