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

'Declaration
 
Function ExcelSetSheetViewProtection( _
   ByVal sheetIndex As Short, _
   ByVal password() As Byte, _
   ByVal sheet As Boolean, _
   ByVal objects As Boolean, _
   ByVal scenarios As Boolean, _
   ByVal formatCells As Boolean, _
   ByVal formatColumns As Boolean, _
   ByVal formatRows As Boolean, _
   ByVal insertColumns As Boolean, _
   ByVal insertRows As Boolean, _
   ByVal insertHyperlinks As Boolean, _
   ByVal deleteColumns As Boolean, _
   ByVal deleteRows As Boolean, _
   ByVal selectLockedCells As Boolean, _
   ByVal sort As Boolean, _
   ByVal autoFilter As Boolean, _
   ByVal pivotTables As Boolean, _
   ByVal 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.ExcelSetSheetViewProtection(sheetIndex, password, sheet, objects, scenarios, formatCells, formatColumns, formatRows, insertColumns, insertRows, insertHyperlinks, deleteColumns, deleteRows, selectLockedCells, sort, autoFilter, pivotTables, 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