Workbook.AcceptAllChanges Method (Excel)
Accepts all changes in the specified shared workbook.
Syntax
expression .AcceptAllChanges(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 accepted. |
Who |
Optional |
Variant |
Specifies by whom all the changes are accepted. |
Where |
Optional |
Variant |
Specifies where all the changes are accepted. |
Example
This example accepts all changes in the active workbook.
ActiveWorkbook.AcceptAllChanges