| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How secure are the file passwords? | Excel Discussion (Misc queries) | |||
| Secure spreadsheet | Excel Discussion (Misc queries) | |||
| Import from a secure site | Excel Discussion (Misc queries) | |||
| Secure Information | Excel Discussion (Misc queries) | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Linear Mode
