Workbook.RejectAllChanges Method (Excel)
Rejects all changes in the specified shared workbook.
Syntax
expression .RejectAllChanges(When, Who, Where)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
When |
Optional |
Variant |
Specifies when all the changes are rejected. |
Who |
Optional |
Variant |
Specifies by whom all the changes are rejected. |
Where |
Optional |
Variant |
Specifies where all the changes are rejected. |
Example
This example rejects all changes in the active workbook.
ActiveWorkbook.RejectAllChanges