Just load the form with the vbModal keyword:
Then change the form properties as follows:
BorderSytle = Fixed Dialog
ControlBox = False
Moveable = False
This will create a pop-up form that will prevent them from doing anything until they enter the correct password. Of course the code for the correct password should unload the form as well as do whatever else you want it to.
Hope this helps.