I have a file that has about 300 links to another worksheet called
Cash0704.xls. Each month a new CashMMYY is created and I update the links to
the new month file. I created a macro that updates the links automatically
based on a month I am prompted for. A password was placed on the CashMMYY
file so now when I run the macro to update the new month every cell the macro
updates requires me to enter a password. With over 300 links this is not
practical. Is there a way in VBA to allow me to just enter the password
once, save it as a variable then use that to update each link without having
to enter the password?