so. need to open about 10 files. all password protected(diff passwords) so information can then be verified and then moved to another excel doc that isn't password protected. reason is i have a master doc that grabs the information from all those documents to get me stats. right now i'm opening the password protected files one at a time. copying the info to another excel doc that isn't password protected then running an update on my master doc to get all this info together. (no, not password protecting anything isn't an option) is there something i can do with this or am i stuck doing it the way i've been doing it so far? i've tried macro's but they don't seem to work.