Code to automatically turn on and turn off Track Changes
 

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
 

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.

--
Regards,
Tom Ogilvy

John wrote in message
...
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