Hi,
I have a spreadsheet in Excel 2010 that contains a list of appx 1000 managers. Each manager on the list has a hyperlink to their spreadsheet in our directory. The spreadsheet also contains the password for each of the managers spreadsheets.
The process today is for the end-user to click on the hyperlink to take them directly to the manager's spreadsheet, but then the end-user must enter the unique password that appears a few columns to the left of the hyperlink to open up the spreadsheet.
Is there a way to create VBA code that will automatically paste in the password that appears in the "password column" so that the end-user does not have to?
I am very inexperienced in VBA so any code you have with descriptions would be very helpful. Thank you!
I have a spreadsheet in Excel 2010 that contains a list of appx 1000 managers. Each manager on the list has a hyperlink to their spreadsheet in our directory. The spreadsheet also contains the password for each of the managers spreadsheets.
The process today is for the end-user to click on the hyperlink to take them directly to the manager's spreadsheet, but then the end-user must enter the unique password that appears a few columns to the left of the hyperlink to open up the spreadsheet.
Is there a way to create VBA code that will automatically paste in the password that appears in the "password column" so that the end-user does not have to?
I am very inexperienced in VBA so any code you have with descriptions would be very helpful. Thank you!
