![]() |
Color Indicator
Is there a means of changing the color of box indicator in
which the cell you move to is diferent. Another words everytime you move to another cell the cursor which is a standard black outlined can be changed. Thanks for your help, hope this was a descriptive enough question. |
Color Indicator
Chip Pearson has an addin that will do what you want (and more):
http://www.cpearson.com/excel/RowLiner.htm The biggest drawback is that like most macros, this disables the Undo feature. Bob wrote: Is there a means of changing the color of box indicator in which the cell you move to is diferent. Another words everytime you move to another cell the cursor which is a standard black outlined can be changed. Thanks for your help, hope this was a descriptive enough question. -- Dave Peterson |
Color Indicator
If you mean you want the activecell to constantly be say "Yellow", then
paste the following into the module named Thisworkbook: Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _ ByVal Target As Excel.Range) On Error Resume Next Sh.Cells.Interior.ColorIndex = xlColorIndexNone Target.Interior.ColorIndex = 6 ' yellow - change as needed End Sub "Dave Peterson" wrote in message ... Chip Pearson has an addin that will do what you want (and more): http://www.cpearson.com/excel/RowLiner.htm The biggest drawback is that like most macros, this disables the Undo feature. Bob wrote: Is there a means of changing the color of box indicator in which the cell you move to is diferent. Another words everytime you move to another cell the cursor which is a standard black outlined can be changed. Thanks for your help, hope this was a descriptive enough question. -- Dave Peterson |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com