Hey guys,

I'm working on a dashboard project atm and i've hit a wall atm.

I want to password protect a hidden sheet which can be accessed through a 'Hyperlink'macro in a chart. The macro towards the sheet is already in place.
This sheet is hidden purely because of lay-out purposes.

This vid almost explains the complete case, but i want it to work when the chart has been clicked, not directly when the file has been opened.
http://www.youtube.com/watch?v=CqjERc9E4jQ

P.S. Will this also keep the user 'logged in'? I've chosen to hide the hidden sheet directly after moving to a different sheet.