Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open Excel Macro to enter passwords

Status
Not open for further replies.

hansretallick

Technical User
Jan 9, 2006
33
GB
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.
 
If you open workbooks with vba, look at Workbooks.Open method 'Password' parameter.

combo
 
Please explain "I am unable to create a macro"?!?!? You are asking advice on what code to put in a macro.

In the meantime, assuming you can actually create a macro, you'd have to store the passwords in the macro ( or some other storage place ). Do you have the passwords? Are you happy about them being stored in this way? You would use them in the way that combo suggests ( opening the supporting documents before opening the master ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top