Workbook.ReplyWithChanges Method (Excel)
Sends an e-mail message to the author of a workbook that has been sent out for review, notifying them that a reviewer has completed review of the workbook.
Syntax
expression .ReplyWithChanges(ShowMessage)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
ShowMessage |
Optional |
Variant |
False does not display the message. True displays the message. |
Remarks
Use the SendForReview method to start a collaborative review of a workbook. If the ReplyWithChanges method is executed on a workbook that is not part of a collaborative review cycle, the user will receive an error.
Example
This example automatically sends a notification to the author of a review workbook that a reviewer has completed a review, without first displaying the e-mail message to the reviewer. This example assumes that the active workbook is part of a collaborative review cycle.
Sub ReplyMsg()
ActiveWorkbook.ReplyWithChanges ShowMessage:=False
End Sub