Protect a worksheet, but allow ONLY specific users to change info

G

Guest

I tried going on the Tools menu, protection, but there is no Allow Users to
Edit Ranges. The worksheet is not protected. I'm working on a computer that
has above Windows 2000 and it's on a domain. Why can't I find it?
 
G

Guest

you can lock or unlock cells and allow users to select(or not) those cells.I
cant help with only allowing certain people,unless you give only certain
people the password.I spose you could write a macro to customize which cells
can be modified by which people
 

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 a user to edit ranges in a protected worksheet 3
Protected worksheet/tab key 2
Allow user to change the state of ("click" in) check-boxes on protected worksheets? 2
when I protect a worksheet, user cannot use check boxes 4
Using tab key in protected worksheet 4
Expanding Grouped Rows when sheet is Protected 2
Insert/ delete row in protected worksheet 7
Cell locking based on domain user 6

Top