For your computer to prompt you for a password when it returns from hibernation, you must select the "Prompt for password when computer goes off standby" check box on the Power Options Advanced tab:
Start the Power Options Control Panel applet (Start, Settings, Control Panel, Power Options).
Select the Advanced tab.
Check the "Prompt for password when computer goes off standby" check box.
Click OK.