VBA to open an external excel file and direct to the specific spreadsheet

Dear all,

This is my first post and need your kind help. I am totally new in VBA.

Here is the case:

I want the user to input 3 things : workbook name, spreadsheet name, password. Then Click on an active button, the required workbook will open, and display the required spreadsheet.

Below is the code i have, but it can only open the specified workbook, not able to direct to the specified spreadsheet. Please help. Thank you all.

Please Login or Register  to view this content.

Please Login or Register  to view this content.