| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect a range of cells but permit highlight
Hello all
How to protect a range of cells in an excel 2003 worksheet? User cannot edit the data. But, s/he can highlight those protected cells? Please give me some suggestions. Thanks Bon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to protect a range of cells but permit highlight
Not 100% sure what you mean by Highlight.
But you can Lock the cells you want prevented from being modified, yet allow the user to select them by: Tools Protection Protect WorkSheet. And Tick the Allow user to Select Locked Cells. Corey.... "Bon" wrote in message oups.com... Hello all How to protect a range of cells in an excel 2003 worksheet? User cannot edit the data. But, s/he can highlight those protected cells? Please give me some suggestions. Thanks Bon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I protect cells or a range of cells in excel spreadsheet? | Excel Worksheet Functions | |||
| I'm unable to highlight a range of cells to copy and paste in exce | Excel Worksheet Functions | |||
| How to permit editing the contents of added row(cells) if previous row is protected? | Excel Discussion (Misc queries) | |||
| paste and highlight the cells of range | Excel Discussion (Misc queries) | |||
| want highlight when all cells in range are equal | Excel Worksheet Functions | |||
Linear Mode
