Claus Busch wrote:

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.

Thanks Clause. Been away fro a while. I'll have another try at this
soon.

--
Terry, East Grinstead, UK