Re: Colours not changing

Oh, and when I use (now) in the 'Case else' statement instead of "" in
the columns(2) line, todays date is presented in the cell.
On 31 mei, 17:50, dqsp <news4...@xxxxxxxxx> wrote:
Hi Norman,

I allready tried that, but no succes.
At home it works (had to do with macroprotection (grr)). At my work it
doesn't. If I debug with F8, I stll see that the macro ends
after .Columns(2).Value = (Now)

Any other idea?

Thanks again,
Rob

On 30 mei, 18:11, "Norman Jones" <normanjo...@xxxxxxxxxxxxxxxxxx>
wrote:



Hi Rob,

Run the following sub and then try
changing column G values.

'========>>
Public Sub Tester()
    Application.EnableEvents = True
End Sub
'<<========

---
Regards.
Norman- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

.

Relevant Pages