How do I create a macro to color a cell only when I click on it?

[Figz]

--
Qwest4Info

[Tom Ogilvy]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 5
End Sub

Uses the Sheets SelectionChange Event. (Placed in the sheets code module;
right click on the sheet tab and select view code)

See Chip Pearson's page on events for reference

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

--
Regards,
Tom Ogilvy


"Figz" <Figz@discussions.microsoft.com> wrote in message
news:3844D93F-2E57-45F6-B0EC-837C7148A6E0@microsoft.com...
>
> --
> Qwest4Info