View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
dqsp dqsp is offline
external usenet poster
 
Posts: 9
Default Colours not changing

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"
wrote:
Hi Rob,

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

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

---
Regards.
Norman