How do i change the color of a cell when tabbing?
How do i change the color of a cell when tabbing so it's easier to move
around spreadsheet knowing where the cursor is located? |
How do i change the color of a cell when tabbing?
You could try Chip Pearson's RowLiner add-in, available he
http://www.cpearson.com/excel/RowLiner.htm Hope this helps. Pete On Dec 18, 2:36*pm, Lisa Z <Lisa wrote: How do i change the color of a cell when tabbing so it's easier to move around spreadsheet knowing where the cursor is located? |
How do i change the color of a cell when tabbing?
Copy the code below to a given worksheet codemodule. Once you do it
and save the excel workbook, on that particular sheet you would see the cell graying out when you tab or move between range or cells. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim mySht As Worksheet Set mySht = Target.Parent mySht.Cells.Interior.ColorIndex = 0 Target.Interior.ColorIndex = 15 End Sub I hope this helps... Selva V Pasupathy For more on Excel, VBA, & other Resources Please visit: http://socko.wordpress.com |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com