Workbook.AcceptAllChanges Method
| Excel Developer Reference |
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.
| Visual Basic for Applications |
|---|
|
See Also