Setting bkcolor on active cell when left mouse doubleclikked
Did this with Macro Recorder:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
End Sub
"Jan Eikeland" wrote in message
...
Environment Office97 excel.
Hi, trying to set backgroundcolor of the cell which beeing doublecliked
With Worksheets("Rodeuker").ActiveCell.Interior.Color = RGB(255, 0, 0)
This doesnt work and I cant figure out, cause cant find anything in
help-file for visual basic part of excel.
Thank You
regards jan
|