| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect a worksheet, but allow ONLY specific users to change info
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect a worksheet, but allow ONLY specific users to change info
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 -- paul remove nospam for email addy! "tara" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect shouldn't default to "allow users to select locked cells" | Setting up and Configuration of Excel | |||
| Only calculate specific worksheet automatically? | Excel Worksheet Functions | |||
| Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
| How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
| Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Hybrid Mode
