View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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