I want to know how an excel worksheet in a Workbook can be hidden and protected and when clicked on the TOC(Table of Content)generated, it should open only by entering a password. In TOC, the worksheet should show up but upon clicking on the link, it should ask for a password to show the worksheet.
I also want to know how to give different passwords for different worksheets.