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,
   ref string algorithmName,
   ref byte[] hashValue,
   ref byte[] saltValue,
   ref uint spinCount
)

'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, _
   ByRef algorithmName As String, _
   ByRef hashValue() As Byte, _
   ByRef saltValue() As Byte, _
   ByRef spinCount As UInteger _
) As Boolean

'Usage
 
Dim instance As IProtectionSupport2
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 algorithmName As String
Dim hashValue() As Byte
Dim saltValue() As Byte
Dim spinCount As UInteger
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, algorithmName, hashValue, saltValue, spinCount)

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].

algorithmName

The algorithm name.

hashValue

the hash value.

saltValue

the salt value.

spinCount

the spin count.

Reference

IProtectionSupport2 Interface
IProtectionSupport2 Members