ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Protect a worksheet, but allow ONLY specific users to change info (https://www.excelbanter.com/excel-worksheet-functions/72489-protect-worksheet-but-allow-only-specific-users-change-info.html)

tara

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?

paul

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?



All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com