Question Locked

Protecting Worksheets in Excel with password

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

This discussion is closed to new replies.