Code to automatically turn on and turn off Track Changes

Code to automatically turn on and turn off Track Changes

Post by John » Wed, 08 Oct 2003 06:22:54


Is there a way to turn Track Changes on and off using code
rather than having the user go up and do it manually when
a macro needs to be run?

Thanks,
John
 
 
 

Code to automatically turn on and turn off Track Changes

Post by Tom Ogilv » Wed, 08 Oct 2003 10:22:02

Look at object.saveas, syntax 2 - the AccessMethod argument. where object
is a workbook object.

Also look in the object browser under the worksheet object for the
attributes associated with history.