Something basic like this might work:
Change mypass to whatever you want to make your password. You can also change the focus of the Range in Sheet2 if you want. (For example, if you want them to go directly to cell E4, change Range("A2") to Range("E4").
If you don't want them checking the vba code for the workbook to find out the password, simply protect it. In the vba window, click Tools-VBA Project Properties-Protection. Check the box for 'Lock project for viewing', type a password and click OK. Save the workbook, close it, then re-open it and your changes will have taken effect.