|Thank you for the answer. I read the link but it seems that it is not my case. |
I don't need to do repeated macros on many sheets, rather, I have one summary excel sheet (only I can access) which are linked to all these protected files (they can be edited by some other people in a shared folder). When the data in those files changed, I would expect the data in my sumamry excel sheet also changes. Now it works but everytime it requires me to key in password for all the protected sheets. I know all the passwords and is it a way that I can store all these passwords so that it never asks me for password and will auto update the data when I open the summary excel sheet?