hansretallick
Technical User
I have a spreadsheet in Excel 2003 which has a number of worksheets which each look up data from separate files in our company web site. Each of the originating spreadsheets is separately password protected, and when the master sheet is opened, it requests passwords in sequence from the originating sheets. Any ideas of a VB code to enter the passwords in turn as they are requested? I am unable to create a macro as the tools menu isn't enabled until the passowrds have been read. A typical cell reference is =' Documents/Targets/[Targets 101.xls]Sheet1'!B33.