다음을 통해 공유


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

.ReplyWithChanges(ShowMessage)

A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

ShowMessage

선택

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

참고 항목

개념

Workbook Object

Workbook Object Members