![]() |
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 |
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 |
All times are GMT +1. The time now is 07:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com