Excel.Workbook.ReplyWithChanges.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.ReplyWithChanges method (Excel)	vbaxl10.chm199207	vbaxl10.chm199207	Excel.Workbook.ReplyWithChanges	60424d69-0062-aa5e-ea8f-4fb07086167a	05/29/2019	medium

Workbook.ReplyWithChanges method (Excel)

Sends an email 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 indicating that a reviewer has completed a review, without first displaying the email 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

[!includeSupport and feedback]