Happy Christmas!

I have an Excel 2007 workbook. The first sheet contains a drop down menu that takes you to other worksheets within the workbook depending upon the selection you make.

However, some of the sheets contain sensitive data that I'd like to password protect. i.e. if someone selects 'LAC' (Sheet10) from the drop down list it will ask them to enter a password BEFORE it opens that worksheet.

Can enyone help?

Thanks

Steve