Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
I posted this twice on the old board and didn't get any response. I really need help with this. Thanx in advance.
I have a summary workbook that is linked to twenty departmental budget workbooks It combines all their info into a company-wide consolidation. All the individual workbooks are password protected with different passwords
The problem is that every time I open the summary w/b, I have to manually input all twenty passwords, one after the other. If I just click "o.k." or "cancel" in the password boxes, the workbook opens, but any change in data in the departmental w/b's is not refreshed on the summary w/b.
I tried writing a macro to open the w/b and input the passwords, but that part of the macro pertaining to passwords was not recorded.
Can anyone help with an opening macro? Thanx in advance.
I have a summary workbook that is linked to twenty departmental budget workbooks It combines all their info into a company-wide consolidation. All the individual workbooks are password protected with different passwords
The problem is that every time I open the summary w/b, I have to manually input all twenty passwords, one after the other. If I just click "o.k." or "cancel" in the password boxes, the workbook opens, but any change in data in the departmental w/b's is not refreshed on the summary w/b.
I tried writing a macro to open the w/b and input the passwords, but that part of the macro pertaining to passwords was not recorded.
Can anyone help with an opening macro? Thanx in advance.