2.5.104 EnhancedProtection

The EnhancedProtection structure specifies protection settings for Shared Features of the Enhanced Protection type as specified by SharedFeatureType.ISFPROTECTION. These settings apply to a protected sheet.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

reserved

A - iprotObjects (1 bit): A bit that specifies whether linked objects or embedded objects can be edited.

B - iprotScenarios (1 bit): A bit that specifies whether scenarios can be edited.

C - iprotFormatCells (1 bit): A bit that specifies whether cells can be formatted.

D - iprotFormatColumns (1 bit): A bit that specifies whether columns can be formatted.

E - iprotFormatRows (1 bit): A bit that specifies whether rows can be formatted.

F - iprotInsertColumns (1 bit): A bit that specifies whether columns can be inserted.

G - iprotInsertRows (1 bit): A bit that specifies whether rows can be inserted.

H - iprotInsertHyperlinks (1 bit): A bit that specifies whether hyperlinks can be inserted.

I - iprotDeleteColumns (1 bit): A bit that specifies whether columns can be deleted.

J - iprotDeleteRows (1 bit): A bit that specifies whether rows can be deleted.

K - iprotSelLockedCells (1 bit): A bit that specifies whether locked cells can be selected.

L - iprotSort (1 bit): A bit that specifies whether cells can be sorted.

M - iprotAutoFilter (1 bit): A bit that specifies whether cells can be filtered.

N - iprotPivotTables (1 bit): A bit that specifies whether PivotTable reports can be created or modified.

O - iprotSelUnlockedCells (1 bit): A bit that specifies whether unlocked cells can be selected.

reserved (17 bits): MUST be zero, and MUST be ignored.