ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change color on active cell (https://www.excelbanter.com/excel-programming/345712-change-color-active-cell.html)

Helen

Change color on active cell
 
Hi there,

I'm planning to protect my sheet and only allow the user to access some
cells. I'm wondering if there is a way to change the color of the cell as
it becomes active (when for instance clicking on it, or using the Tab key)
so that the user easily can see where he/she's at?

Thanks,

Helen



Norman Jones

Change color on active cell
 
Hi Helen,

See Chip Pearson at:

http://www.cpearson.com/excel/RowLiner.htm

---
Regards,
Norman



"Helen" wrote in message
...
Hi there,

I'm planning to protect my sheet and only allow the user to access some
cells. I'm wondering if there is a way to change the color of the cell as
it becomes active (when for instance clicking on it, or using the Tab key)
so that the user easily can see where he/she's at?

Thanks,

Helen





All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com