Hi
I have simple code
Sub HOL()
' HOL Macro
With Selection.Interior
.Color = 65280
End With
End Sub
This just enters the colour for holiday , this is for hours worked so it needs to show 0,
how can I do this so-
When the user selcts HOL it enters the color (green in this case) and 0?
Mabe simple but got me stumped
I have simple code
Sub HOL()
' HOL Macro
With Selection.Interior
.Color = 65280
End With
End Sub
This just enters the colour for holiday , this is for hours worked so it needs to show 0,
how can I do this so-
When the user selcts HOL it enters the color (green in this case) and 0?
Mabe simple but got me stumped