[Advanced Excel] After Protecting Sheet Formatting Cells To Be Unlocked is Ignored

Forge Component
Published on 2019-08-27 by Hanno
59 votes
Published on 2019-08-27 by Hanno


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