Excel 2007
I can't tell, easily, what cell I'm in and find myself keying in the wrong
cell. Is there any way to make the active cell more visible? |
Excel 2007
Hi,
Two things you might consider: 1. Note that as you move from cell to cell you see the cell address in the Name Box to the left of the Formula Bar and the Column letter and Row number of the active cell are shaded, orange in 2003. 2. You could install the following code: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Static LastCell On Error Resume Next ActiveCell.Interior.ColorIndex = 40 Range(LastCell).Interior.ColorIndex = 0 LastCell = Target.Address End Sub If this is helpful, please click the Yes button. -- Thanks, Shane Devenshire "Gator Girl" wrote: I can't tell, easily, what cell I'm in and find myself keying in the wrong cell. Is there any way to make the active cell more visible? |
All times are GMT +1. The time now is 03:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com