Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLSheetMBS class.

Previous items Next items

XLSheetMBS.ProtectInsertColumns = 32

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Inserting columns is allowed when the sheet is protected.

XLSheetMBS.ProtectInsertHyperlinks = 128

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Inserting hyperlinks is allowed when the sheet is protected.

XLSheetMBS.ProtectInsertRows = 64

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Inserting rows is allowed when the sheet is protected.

XLSheetMBS.ProtectObjects = 1

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Objects are locked when the sheet is protected.

XLSheetMBS.ProtectPivottables = 8192

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Pivot tables are allowed when the sheet is protected.

XLSheetMBS.ProtectScenarios = 2

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Scenarios are locked when the sheet is protected.

XLSheetMBS.ProtectSelLockedCells = 1024

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Selection of locked cells is locked when the sheet is protected.

XLSheetMBS.ProtectSelUnlockedCells = 16384

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Selection of unlocked cells is locked when the sheet is protected.

XLSheetMBS.ProtectSort = 2048

Type Topic Plugin Version
const XL MBS XL Plugin 16.5
One of the protection levels.

Sorting is allowed when the sheet is protected.

XLSheetMBS.ScopeUndefined = -2

Type Topic Plugin Version
const XL MBS XL Plugin 14.0
One of the scope constants.

Undefined scope

XLSheetMBS.ScopeWorkbook = -1

Type Topic Plugin Version
const XL MBS XL Plugin 14.0
One of the scope constants.

Workbook scope.

XLSheetMBS.SheetStateHidden = 1

Type Topic Plugin Version
const XL MBS XL Plugin 12.1
One of the constants for the visible state of a sheet.

Sheet is hidden, but can be shown via the user interface.

XLSheetMBS.SheetStateVeryHidden = 2

Type Topic Plugin Version
const XL MBS XL Plugin 12.1
One of the constants for the visible state of a sheet.

Sheet is hidden and cannot be shown in the user interface.

XLSheetMBS.SheetStateVisible = 0

Type Topic Plugin Version
const XL MBS XL Plugin 12.1
One of the constants for the visible state of a sheet.

Sheet is visible

XLSheetMBS.ValidationErrstyleInformation = 2

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the error styles.

This data validation error style uses an information icon in the error alert.

XLSheetMBS.ValidationErrstyleStop = 0

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the error styles.

This data validation error style uses a stop icon in the error alert.

XLSheetMBS.ValidationErrstyleWarning = 1

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the error styles.

This data validation error style uses a warning icon in the error alert.

XLSheetMBS.ValidationOpBetween = 0

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is between two other values.

XLSheetMBS.ValidationOpEqual = 2

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is equal to a specified value.

XLSheetMBS.ValidationOpGreaterthan = 6

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is greater than a specified value.

XLSheetMBS.ValidationOpGreaterthanorequal = 7

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is greater than or equal to a specified value.

XLSheetMBS.ValidationOpLessthan = 4

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is less than a specified value.

XLSheetMBS.ValidationOpLessthanorequal = 5

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is less than or equal to a specified value.

XLSheetMBS.ValidationOpNotbetween = 1

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is not between two other values.

XLSheetMBS.ValidationOpNotequal = 3

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the validation operations.

Data validation which checks if a value is not equal to a specified value.

XLSheetMBS.ValidationTypeCustom = 7

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the constants for the types of data validation.

Data validation which uses a custom formula to check the cell value.

XLSheetMBS.ValidationTypeDate = 4

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the constants for the types of data validation.

Data validation which checks for date values satisfying the given condition.

XLSheetMBS.ValidationTypeDecimal = 2

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the constants for the types of data validation.

Data validation which checks for decimal values satisfying the given condition.

XLSheetMBS.ValidationTypeList = 3

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the constants for the types of data validation.

Data validation which checks for a value matching one of list of values.

XLSheetMBS.ValidationTypeNone = 0

Type Topic Plugin Version
const XL MBS XL Plugin 17.2
One of the constants for the types of data validation.

No data validation.

Previous items Next items

The items on this page are in the following plugins: MBS XL Plugin.


💬 Ask a question or report a problem
The biggest plugin in space...