Track Change, Help!
"KI LEE" wrote in message
...
Hi All,
Is it possible that to right VBA code in Excel to activate the "Track
Change" functionality in each cell?
It is very good features that to keep the version changes but it seems not
open for programming. Is it?
Thx.
A simple check for this (or anything else) is to start a macro
recording, then do what you want to code by hand with the mouse. Stop
recording, and have a look at the code generated.
Looking at the help file, it doesn't seem possible. There are various
properties and methods of a workbook to examine or set things to do with the
change tracking, but there doesn't seem to be anything to turn it on or
ff - though you can test to see if it is on. Look up the Workbook object
in the helpfile, and have a look through the properties and methods.
Iain King
|