Here's the scenario. I've got 10 staff who each have their own workbook. They put their figures in as they work, and I have created an overview workbook so I can see their work.
I've created a simple bit of code in VBA to pull the info from their workbooks and put it in my workbook as and when required, with a little button.
All the staff workbooks are password protected, so I've taken that into account in the code, and it works perfectly.
Unless...one of the staff has their workbook open at the time I press my little button, then I am prompted for their password. If 5 staff have their workbooks open then I am required to type 5 passwords.
My question then, is there a way to bypass asking for the password in their workbook is open, maybe having the workbook shared would be the answer? Another solution would be to force close their workbook (after saving it of course) and then running my code to extract the info I need? Is this possible?
Any help would be appreciated as I've struggled for a few days with this one.