| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect a sheet so only certain people can view it...
I work for a Large fortune 500 company and I've got an Excel sheet on a
shared drive...I say that so you know i don't have "administrator" rights...I need to keep it there, but i want to protect it so that only a select group of people with passwords can open it...is there a way to do this? I have someone from another department who goes into my file to look at our data and we do not want her doing that... Thanks!! ~JC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect a sheet so only certain people can view it...
file/save as/tools/general options/
you can specify read or modify passwords "JC" wrote: I work for a Large fortune 500 company and I've got an Excel sheet on a shared drive...I say that so you know i don't have "administrator" rights...I need to keep it there, but i want to protect it so that only a select group of people with passwords can open it...is there a way to do this? I have someone from another department who goes into my file to look at our data and we do not want her doing that... Thanks!! ~JC |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect a sheet so only certain people can view it...
Perfect!! Awesome!! Thanks!
"dlw" wrote: file/save as/tools/general options/ you can specify read or modify passwords "JC" wrote: I work for a Large fortune 500 company and I've got an Excel sheet on a shared drive...I say that so you know i don't have "administrator" rights...I need to keep it there, but i want to protect it so that only a select group of people with passwords can open it...is there a way to do this? I have someone from another department who goes into my file to look at our data and we do not want her doing that... Thanks!! ~JC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I stop people opening an excel sheet? | Excel Discussion (Misc queries) | |||
| Can you protect a sheet so that no one else can print, only view? | Excel Worksheet Functions | |||
| Password protect for view only | Excel Discussion (Misc queries) | |||
| Protect to view VBE in Excel | New Users to Excel | |||
| Don't allow certain people to view worksheets | Setting up and Configuration of Excel | |||
Linear Mode
