Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off track changes in a shared workbook | Excel Discussion (Misc queries) | |||
Turn off track changes in shared book | Excel Discussion (Misc queries) | |||
"Track Changes" - Prevent turn off track changes to meet SOX regs | Excel Discussion (Misc queries) | |||
Turn AutoFilter off by code? | Excel Programming | |||
Turn this into VBA code | Excel Programming |