Problem: Possible to delete locked cells in protected Sheets

Hi Everyone,

I have been trying to solve this for quite a while but I do not seem to find the solution. I have a macro to protect all Sheets in a workbook in Excel 2010. Below the code:

Please Login or Register  to view this content.

When I try to edit/delete the content of 1 cell Excel says that it is protected. However, when I select more than 1 cell (including locked cells) I can delete the content!! (FYI: I need the user to be able to select locked cells in a protected workbook).

Any idea why this is happening?

Thank you very much in advance!

Best,
Daniel

Hi Community,

First of all, thank you for the response. I have been trying to solve it during the weekend and I finally found the problem.

I had a Worksheet_SelectionChange event to unhide/hide a number of rows when the user selects 2 specific cells. At the beginning of the macro I unprotected the sheet and then protect it at the end of the macro.

The problem was that when the user selected 2 or more cells but not the target ones, the event started un-protecting the sheet. Here is the fix:

Code:

Please Login or Register  to view this content.

Just in case someone needs it.

Cheers,
Daniel