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

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

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