allow users to edit ranges

G

Guest

I have a few cells in a range say Range 1 in a worksheet of a workbook which
I want to be modifiable only by a few users say Managers. For this, I locked
these cells through format cells protection property. And then implemented
'Allow users to edit ranges' for Range 1. It works fine: it asks for a
password when one is trying to modify any of these cells in Range1. But the
problem is that while protecting my sheet, I had to allow all users from
selecting locked cells otherwise Managers cant even select cells in Range1.
And due to this, all users of this sheet can select even locked cells (though
they cant change them) which I dont want them to. Is there a way to preven
this?
 
A

Alan

If you check 'Locked' and 'Hidden' on all cells it makes no difference if
users can select the protected cells or not as they cant see whats in them,
or am I missing something?
Regards,
Alan.
 
G

Guest

'Hidden' is not an issue here.

Alan said:
If you check 'Locked' and 'Hidden' on all cells it makes no difference if
users can select the protected cells or not as they cant see whats in them,
or am I missing something?
Regards,
Alan.
Click to expand...
 

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

Similar Threads

allow merging cells in protected sheet 1
copy cells but lock editing 5
Allow Users to Edit Ranges??? 8
Locked Several Worksheets, allow format cells/select unlocked cell 2
Locked Property off, but cannot select cell 3
Enter value zero into all cells in multiple ranges? 4
Allow users to edit range query 7
Unprotecting worksheets 2

Top