'Declaration
 
Function ExcelGetSheetViewProtection( _
   ByVal sheetIndex As Short, _
   ByRef password() As Byte, _
   ByRef sheet As Boolean, _
   ByRef objects As Boolean, _
   ByRef scenarios As Boolean, _
   ByRef formatCells As Boolean, _
   ByRef formatColumns As Boolean, _
   ByRef formatRows As Boolean, _
   ByRef insertColumns As Boolean, _
   ByRef insertRows As Boolean, _
   ByRef insertHyperlinks As Boolean, _
   ByRef deleteColumns As Boolean, _
   ByRef deleteRows As Boolean, _
   ByRef selectLockedCells As Boolean, _
   ByRef sort As Boolean, _
   ByRef autoFilter As Boolean, _
   ByRef pivotTables As Boolean, _
   ByRef selectUnlockedCells As Boolean _
) As Boolean

'Usage
 
Dim instance As IProtectionSupport
Dim sheetIndex As Short
Dim password() As Byte
Dim sheet As Boolean
Dim objects As Boolean
Dim scenarios As Boolean
Dim formatCells As Boolean
Dim formatColumns As Boolean
Dim formatRows As Boolean
Dim insertColumns As Boolean
Dim insertRows As Boolean
Dim insertHyperlinks As Boolean
Dim deleteColumns As Boolean
Dim deleteRows As Boolean
Dim selectLockedCells As Boolean
Dim sort As Boolean
Dim autoFilter As Boolean
Dim pivotTables As Boolean
Dim selectUnlockedCells As Boolean
Dim value As Boolean
 
value = instance.ExcelGetSheetViewProtection(sheetIndex, password, sheet, objects, scenarios, formatCells, formatColumns, formatRows, insertColumns, insertRows, insertHyperlinks, deleteColumns, deleteRows, selectLockedCells, sort, autoFilter, pivotTables, selectUnlockedCells)

bool ExcelGetSheetViewProtection( 
   short sheetIndex,
   ref byte[] password,
   ref bool sheet,
   ref bool objects,
   ref bool scenarios,
   ref bool formatCells,
   ref bool formatColumns,
   ref bool formatRows,
   ref bool insertColumns,
   ref bool insertRows,
   ref bool insertHyperlinks,
   ref bool deleteColumns,
   ref bool deleteRows,
   ref bool selectLockedCells,
   ref bool sort,
   ref bool autoFilter,
   ref bool pivotTables,
   ref bool selectUnlockedCells
)

Parameters

sheetIndex

Index of the sheet.

password

The password.

sheet

if set to true [sheet].

objects

if set to true [objects].

scenarios

if set to true [scenarios].

formatCells

if set to true [format cells].

formatColumns

if set to true [format columns].

formatRows

if set to true [format rows].

insertColumns

if set to true [insert columns].

insertRows

if set to true [insert rows].

insertHyperlinks

if set to true [insert hyperlinks].

deleteColumns

if set to true [delete columns].

deleteRows

if set to true [delete rows].

selectLockedCells

if set to true [select locked cells].

sort

if set to true [sort].

autoFilter

if set to true [auto filter].

pivotTables

if set to true [pivot tables].

selectUnlockedCells

if set to true [select unlocked cells].

Reference

IProtectionSupport Interface
IProtectionSupport Members