Forum Discussion

zorgnum's avatar
zorgnum
Brass Contributor
Sep 12, 2023

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.

 

Edit Objects: I have shapes on the sheet that I want users to be able to edit and/or delete when necessary.

 

If I double click on a locked cell with a formula in it three times, it opens up for editing the formula in that cell, then I can select every cell on the sheet, locked or not.

 

Does anyone know what could be causing this and a workaround??

I really don't want people mucking around in my formulas

  • zorgnum's avatar
    zorgnum
    Brass Contributor
    my workaround is to catch the worksheet change and, if the cell is locked, run an application.undo on that cell

Share