Hi Terry,

Am Thu, 25 Aug 2016 16:54:44 +0100 schrieb Terry Pinnell:

As you see from this screenshot, I'm plainly doing something wrong.
Neither your code nor that from GS to change the 'theme' is working.

download from he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
the workbook "DateFormat"
There is a solution for Worksheet_Change event, for working with simple
macro and for CF.


Regards
Claus B.
--
Windows10
Office 2016