View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sandyboy sandyboy is offline
external usenet poster
 
Posts: 7
Default 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?