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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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
Excel 2003 - Protecting Cells but allowing external data updates 3
How can I merge unprotected cells in a protected worksheet? 1
Allow user to change the state of ("click" in) check-boxes on protected worksheets? 2
Copy protection from one worksheet to another 2
Protect Sheet - But have button to add more lines 1
when I protect a worksheet, user cannot use check boxes 4
Protecting specific columns within a worksheet 1

Back
Top