Hi Terry,

Am Thu, 25 Aug 2016 18:32:33 +0100 schrieb Terry Pinnell:

The code now in Personal.xls pasted from the download is the same as
before, when I had pasted it as usual from my offline email/newsgroup
program (Agent).
And it's the same as the previous code pasted to the one workbook.

But if I enter dates in col C as before, the changes do not appear.

https://dl.dropboxusercontent.com/u/...cel-VBA-05.jpg

the Worksheet_Change code must be in your workbook "SWCP 2016
Summary-Edit". In the PERSONAL you can paste the code from the standard
module.
Change in the 2. line Range("A:A") to Range("C:C")
The code only works in this spezific column.
Then select a cell with a date, press F2 and Enter.
If then the format doesn't change try:

Sub Events
Application.EnableEvents=True
End Sub
and try again.


Regards
Claus B.
--
Windows10
Office 2016