93
Views
1
Comments
[Advanced Excel] After Protecting Sheet Formatting Cells To Be Unlocked is Ignored
Question
Forge component by Carlos Freitas
68
Published on 27 Aug 2019

Hi,

I am assuming I am setting this up correctly

My requirement is to lock the header row and block users from adding or removing columns.

I have protected the sheet and left the  allowInsertColumns and allowDeleteColumns as default(false)

set the other allows to true

used the CellFormat_ApplyToRange to set the locked state to false for row 2 column 1 to end of column/row

in the resulting spreadsheet all rows/columns are still locked

when I unprotect sheet and check protection they are in a locked state.

It seems the locked state of the format is being ignored


Rank: #15925

Same problem here, has anyone come up with a solution?