How to hide and secure ranges in worksheet
 

To mainatin confidentiality of some data, may want to allow reader to read
certain range or cells but not all, is there a way to hide AND secure
ragnes/cells from reader?

How to hide and secure ranges in worksheet
 

Not completely. Please read:
http://www.officearticles.com/misc/a...t_off ice.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"John" wrote in message
...
To mainatin confidentiality of some data, may want to allow reader to read
certain range or cells but not all, is there a way to hide AND secure
ragnes/cells from reader?

How to hide and secure ranges in worksheet
 

What i usually do is "hide" the columns/rows i'd like to secure then protect
the sheet, so the reader will not be able to unhide the columns/rows unless
he/she enters your password.

Hope i helped
--
sandyboy


"Anne Troy" wrote:

Not completely. Please read:
http://www.officearticles.com/misc/a...t_off ice.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"John" wrote in message
...
To mainatin confidentiality of some data, may want to allow reader to read
certain range or cells but not all, is there a way to hide AND secure
ragnes/cells from reader?

How to hide and secure ranges in worksheet
 

Note that one doesn't have to enter "your" password:

http://www.mcgimpsey.com/excel/removepwords.html

In article ,
sandyboy wrote:

What i usually do is "hide" the columns/rows i'd like to secure then protect
the sheet, so the reader will not be able to unhide the columns/rows unless
he/she enters your password.