Track Changes Tab


Markup

microsoft excel docs
Application.Options.InsertedTextMark = wdInsertedTextMark.wdInsertedTextMarkNone 
Application.Options.InsertedTextColor = wdColorIndex.wdByAuthor
Application.Options.DeletedTextMark = wdDeletedTextMark.wdDeletedTextMarkStrikeThrough
Application.Options.DeletedTextColor = wdColorIndex.wdByAuthor
Application.Options.RevisedPropertiesMark = wdRevisedPropertiesMark.wdRevisedPropertiesMarkNone
Application.Options.RevisedPropertiesColor = wdColorIndex.wdByAuthor
Application.Options.RevisedLinesMark = wdRevisedLinesMark.wdRevisedLinesMarkOutsideBorder
Application.Options.RevisedLinesColor = wdColorIndex.wdAuto
Application.Options.CommentsColor = wdColorIndex.wdByAuthor

Ballons

microsoft excel docs
ActiveWindow.View.RevisionsMode = wdRevisionsMode.wdInLineRevisions 
ActiveWindow.View.RevisionsBalloonSide = wdRevisionsBalloonMargin.wdRightMargin
ActiveWindow.View.RevisionsBalloonWidthType = wdRevisionsBalloonWidthType.wdBalloonWidthPoints
ActiveWindow.View.RevisionsBalloonWidth = Application.PixelsToPoints(208)
ActiveWindow.View.RevisionsBalloonShowConnectingLines = True

Printing

microsoft excel docs
Application.Options.RevisionsBalloonPrintOrientation = wdRevisionsBalloonPrintOrientation.wdBalloonPrintOrientationPreserve 

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext