View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rich
 
Posts: n/a
Default Password protect cell ranges NOT sheet



In order to give specific users access to ranges, your computer must be on a
domain.

On the Tools menu, point to Protection, and then click Allow Users to Edit
Ranges.

Click New.

In the Title box, type a title for the range you're granting access to.

In the Refers to cells box, type an equal sign (=), and then type a
reference or select the range.

In the Range password box, type a password to access the range.

Click Permissions, and then click Add.

Locate and select the users to whom you want to grant access.

Repeat the previous steps for each range for which you're granting access.

Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges
dialog box.

In the Protect Sheet dialog box, make sure the Protect worksheet and
contents of locked cells check box is selected, type a password for the
worksheet, click OK, and then retype the password to confirm.