Thread: Protect worksheet names

In a collaborative environment where workbooks are shared, you might want to protect worksheet names. Here's how:



1.In the Review tab, choose Protect workbook in the Changes group. This will open the Protect Structure and Windows dialog box.

2.Select the Structure check box and enter a password in the Password box.

3.Click on OK. Excel will prompt to re¬enter the password; do so.