ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to protect a range of cells but permit highlight (https://www.excelbanter.com/excel-programming/381794-how-protect-range-cells-but-permit-highlight.html)

Bon

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


Corey

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