PC Review


Reply
Thread Tools Rate Thread

Add Permission did not work in "Allow User to Edit Ranges"

 
 
=?Utf-8?B?aHNpbmxpbjU4?=
Guest
Posts: n/a
 
      22nd May 2006
Hello,

I am trying out the feature of "Allow User to Edit Ranges" in Excel using
the following on-line help:
---------------------------------------------------------------------------------------------
In order to give specific users access to ranges, your computer must be
running Windows 2000 or later and it must be on a domain.

1. On the Tools menu, point to Protection, and then click Allow Users to
Edit Ranges. (This command is available only when the worksheet is not
protected.)

2. Click New.

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

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

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

The password is optional; if you don't supply a password, any user will be
able to edit the cells.

6. Click Permissions, and then click Add.

7. Locate and select the users to whom you want to grant access. If you want
to select multiple users, hold down CTRL while you click the names.

8. Click OK twice. If prompted, retype the password.

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

10. To retain a separate record of the ranges and users, select the Paste
permissions information into a new workbook check box in the Allow Users to
Edit Ranges dialog box.

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

12. 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.

Note A sheet password is required to prevent other users from being able to
edit your designated ranges. Make sure you choose a password you can
remember, because if you lose the password, you cannot gain access to the
protected elements on the worksheet.

--------------------------------------------------------------------------------------------

I had specified the users in step 7 and setup password but I am finding out
that anyone that knows the password can edit the range. Also when I tried to
modify the permission list, there's nothing to modify.

From the instruction above (step 1 - 12), it seemed to indicate we need to
specify user name to grant the editing right. But from the menu itself, it
seemed to indicate the user list is to grant editing right without the
password.
I am confused about which is the correct. Please help, thanks.

hsinlin58

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding commands to "Folder Options/Edit File Type/Actions" grayed-out "Edit" & "Remove" Green_XP Windows XP Basics 1 6th Nov 2007 08:48 AM
Adding commands to "Folder Options/Edit File Type/Actions" grayed-out "Edit" & "Remove" Green_XP Windows XP Customization 1 6th Nov 2007 08:48 AM
Adding commands to "Folder Options/Edit File Type/Actions" grayed-out "Edit" & "Remove" Green_XP Windows XP General 1 6th Nov 2007 08:48 AM
Adding commands to "Folder Options/Edit File Type/Actions" grayed-out "Edit" & "Remove" Green_XP Windows XP Help 1 6th Nov 2007 08:48 AM
Allow user to edit Ranges under "Protection" Wellie Microsoft Excel Programming 1 29th Feb 2004 12:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:59 AM.