Forum Discussion
Excel worksheets unprotecting unexpectedly
Hi all, I just found a very unfortunate undocumented feature in excel. I have a protected worksheet with the following features: Select unlocked cells, Format cells, and Edit Objects all selected. ...
my workaround is to catch the worksheet change and, if the cell is locked, run an application.undo on that cell