Excel 2007 : Locking Sheets from View

I have a workbook that has a password-protect to open, but within the workbook, there are some worksheets that are sensitive and should be viewed only by higher management. Is there any way to select those worksheets and password-protect them from being able to view?

We have looked at the possible action of just formulating a separate workbook, but higher management prefers everything in one workbook if at all possible.

Thanks in advance!

You can use the xlVeryHidden property for the sheets("Sheet1").Visible and then create a button to ask for a password and unhide the sheets.