View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode via OfficeKB.com Chris Bode via OfficeKB.com is offline
external usenet poster
 
Posts: 47
Default Active Cell Highlight

In excel 2007, the color range is light that is why it is quite difficult to
see the selected cell. If you prefer to use macro to resolve this problem ,
then the solution could be like this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Interior.Color = 1 provide numeric color value here that
will €˜appear as background color of 'the selected cell
End Sub

Hope you get it

Have a nice time

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1