Tame your computer – hide and seek

23 Apr

When you share a workbook with other users, you may want to hide a specific worksheet to prevent it from being seen or changed. You can then protect the worksheet using VBA, but there is a simple way of doing this without writing code.

Here’s how:

  1. Right-click the worksheet you want to hide and click Hide.
  2. On the Review tab, in the Changes group, click on the Protect Workbook button.
  3. Be sure the Structure box is ticked and that the insertion point is located in the Password box. Enter a password of your choice and click on OK or press ENTER.
  4. Reenter the password and click OK or press ENTER.

Only those users who know the password will now be able to unhide the sheet.

Here’s how to unhide:

  1. On the Review tab, in the Changes group, click on the Protect Workbook button.
  2. Enter the password and click OK or press ENTER.
  3. Right-click on any of the sheets and click Unhide.
  4. In the Unhide dialog box, select the worksheet that is to be unhidden and click on the OK button.

By the way, do not confuse this feature with protecting your whole workbook file by using a password. See Tip 253 for further details.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: