Identifies the action that led to the prompt being displayed.

Enumeration Members

ChangePartOfDataTable: 27

Changes cannot be made to only a portion of the data table.

ClearCellContentError: 0

An error occurred while clearing the contents of the selected cells.

ConflictingWorksheetName: 4

The name entered during an in-place edit/rename of a Worksheet Name conflicts with the name of an existing Worksheet.

CopyError: 17

An unspecified error occurred during a copy operation.

CopyInvalidRanges: 19

The selection is invalid for a copy operation. If there are multiple ranges then the items must have the same start and end row or start and end column without overlapping and without leaving any gaps.

DeletingLockedColumnCells: 28

One or more cells are locked within the columns that are being deleted.

DeletingLockedRowCells: 29

One or more cells are locked within the rows that are being deleted.

DeletingWorksheets: 5

One or more worksheets are being deleted which may result in loss of data.

EditError: 2

An error occurred while attempting to update the active cell or selected cells while exiting edit mode.

FormulaParseError: 1

An error occurred while parsing the formula entered while in edit mode.

General: 20

An error occurred during some operation other than the ones relating to the other members of this enum.

IntersectsMergedCells: 18

The target range(s) intersect with but does not contain one or more merged cells.

InvalidArrayFormulaLockedState: 26

The Locked state of the target cells for an array formula are not consistent.

InvalidCommandForMixedCellSelections: 8

A command was being invoked that isn't valid when there are a combination of rows or columns and cells selected.

InvalidCommandForMultipleSelections: 7

A command was being invoked that isn't valid when there is more than one selected cell ranges.

InvalidCommandForOverlappingSelections: 6

A command was being invoked that isn't valid when there are selected cell ranges that overlap.

InvalidHyperlinkAddress: 22

An error occurred while trying to navigate to the target address of a hyperlink.

InvalidHyperlinkReference: 23

The hyperlink is a reference to a location within the workbook but that location is not a location that currently exists.

InvalidNameBoxValue: 9

A value was entered into the name box of the formula bar that did not represent the address to navigate to nor a valid name to use for the selection.

InvalidProtectedWorksheetChange: 24

The operation being performed involves one or more cells that are locked in a protected Worksheet.

InvalidSortOrFilterRange: 31

The specified or calculated range for the operation is not valid. It may not intersect the used range or may contain table and non-table regions.

InvalidWorksheetName: 3

The name entered during an in-place edit/rename of a Worksheet Name violates the constraints.

LargeCopyOperation: 32

The copy operation will include a large number of cells and may take a long time to complete.

LargePasteOperation: 30

The paste operation will affect a large number of cells and may take a long time to complete.

NoSingleAllowedEditRange: 25

The operation being performed involves one or more cells that are locked but not all the locked cells can be unlocked by a single range or not all required ranges were unlocked when the [[Spreadsheet.editRangePasswordNeeded]] event was invoked.

PasteCellRangeSize: 10

The source area and target areas of the paste operation do have have the same size.

PasteError: 14

An unspecified error occurred during a paste operation.

PasteIntersectsMergedCells: 15

The target range(s) intersect with but does not contain one or more merged cells.

PasteInvalidSheetCount: 13

The number of selected sheets in the target workbook is not an integral multiple of the number of selected sheets in the source workbook.

PasteInvalidSourceRanges: 12

The selection in the source is invalid. Either it is empty/unset or there are multiple cell ranges in the source that do not form a valid copy selection. There must be at least 1 cell range selected and all items must have the same start and end row or start and end column without overlapping and without leaving any gaps.

PasteMultipleSheetsTables: 16

A paste of one or more tables cannot be performed when multiple worksheets are selected.

PasteMultipleSourceAndTargetRanges: 11

There are multiple cell ranges in the source and target sheets.

TableChangeWithMultipleSelectedSheets: 21

The operation cannot be performed when there are multiple sheets selected and the change would affect a table in one of the worksheets.