Allow Users to Edit Ranges???

M

MarcusA

I'm not sure if I'm doing something wrong. I have a workbook with two
worksheets. On the first worksheet, I have standard p/w protection with
several unlocked cells. What I would like to do is grant specific users
access to additional cells within the worksheet. I list my ranges, add users
to the permissions list and select a password. How does the user unlock this
area of the worksheet using the p/w? Secondly, trying the same process and
not using a p/w does not work either.

Thanks
 
D

Dave Peterson

Once you protect the worksheet and allow ranges to be changed, anyone who tries
to change one of those ranges will be prompted for a password. There's nothing
you have to do special. Excel will do it for you.
 
M

MarcusA

The user is unable to selected the locked cell. It does not prompt the user
for a p/w. Does it matter if the cells are locked and the worksheet
protected?
 
D

Dave Peterson

If you protected the sheet and told excel not to let users select locked cells,
then remove this option.
 
M

MarcusA

When I tried this, all users were able to enter data into the range. How do
I restrict access to the range for certain users and allow access for those I
grant permissions too in a protected worksheet or workbook? Should I look at
a macro to perform this function?
 
D

Dave Peterson

I wouldn't use a macro.

Did you protect the worksheet, too?

Are the other users using xl2002+?
When I tried this, all users were able to enter data into the range. How do
I restrict access to the range for certain users and allow access for those I
grant permissions too in a protected worksheet or workbook? Should I look at
a macro to perform this function?
 
M

MarcusA

Yes. I protected the worksheet with say 15 unlocked cells for a set of users
to enter data using format>protection and then protecting the entire workshee.

I do not have a macro for this feature and all of the users in my test group
are on Excel 2002...in Production several may have 2003.
 
D

Dave Peterson

Try locking (format|cells|Protection tab) those 15 cells that only certain
people can change.

Yes. I protected the worksheet with say 15 unlocked cells for a set of users
to enter data using format>protection and then protecting the entire workshee.

I do not have a macro for this feature and all of the users in my test group
are on Excel 2002...in Production several may have 2003.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top