Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Switch on track changes in a workbook from code?
- Thread starter AlexmacG
- Start date
Something like this ?
With Workbooks("Your workbook name")
.HighlightChangesOptions _
When:=xlSinceMyLastSave, _
Who:="Everyone"
.ListChangesOnNewSheet = True
End With
Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
With Workbooks("Your workbook name")
.HighlightChangesOptions _
When:=xlSinceMyLastSave, _
Who:="Everyone"
.ListChangesOnNewSheet = True
End With
Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
