I am new to macros, not to excel. I have a recap worksheet that gathers
information from various password protected worksheets. When I update the
recap worksheet, I have to enter each password every time before the data is
updated. How do I automatically have the passwords entered, either through a
macro or a formula?