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.

"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

Hi,

I have tried but nothing has been recorded. So what's the problem?

Also it is prompt to stop any VBA programming running during marco is
recording, do anyone know y?

KI LEE

"Iain King" wrote:


"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

I have tried but nothing has been recorded. So what's the problem?


I'd guess that means there is no way to turn on change track in a macro.

Iain King