most recently used list

[Guest]

Hello:

I would like to have a group of people to have access to everything in the
worksheet and another group to to be able to edit just one column and view
the rest. I tried to use Allow Users to Edit Ranges but it does not seem to
take effect.

Can you help? Thanks.

 

[Guest]

My previous question's subject was to be Cell/column permission protection.
I am not sure if I can modify posted message.

 

[Dave Peterson]

This type of worksheet protection was added in xl2002. What version of excel do
your users have?

And what do you mean by "does not seem to take effect"?

 

[Guest]

Hello Dave:
I am using Excel 2002 running on Windows XP in the NT network environment.

Let's say that I have 2 users and use Allow users to edit ranges

User 1 - gets Allow users to edit col 1 range and col2 ranges box Allow
selected for user 1
User 2 - gets col 1 range edit set to deny and col 2 range edit set to
allow for user 2

Then I protect the worksheet.

Then I log to network as user 1 and test if I can enter data. Then I log as
user 2. Both users have the same rights, eg. cannot edit first and can edit
second column.

I must be doing something wrong. Can you help?

 

[Dave Peterson]

How did you set the password for the ranges--in the
tools|protection|allow users to edit range dialog?

Then did you protect the worksheet?

If you gave a different password to each range (and share only the password that
each group should know), then when the user attempts to change a cell in one of
those ranges, they should get a password dialog to pop up.

When they type in their topsecret password (that you shared), that range should
be available for editing.

This kind of protection isn't based on the user's permissions.

Hello Dave:
I am using Excel 2002 running on Windows XP in the NT network environment.

Let's say that I have 2 users and use Allow users to edit ranges

User 1 - gets Allow users to edit col 1 range and col2 ranges box Allow
selected for user 1
User 2 - gets col 1 range edit set to deny and col 2 range edit set to
allow for user 2

Then I protect the worksheet.

Then I log to network as user 1 and test if I can enter data. Then I log as
user 2. Both users have the same rights, eg. cannot edit first and can edit
second column.

I must be doing something wrong. Can you help?

 

[Guest]

Hello Dave:

Thanks for explaining this to me so clearly - I thought that the rights are
based on the user's permissions set on the specific network. I would need to
obtain user's group via some VBA procedure, I believe. I will ask my users
if they want to use a password to access cells that they have rights to
edit..