Excel Friends,
I found this proven code to Unlock only Empty Cells. I tested in my active sheet that has many vertical and horizontal merged cells. it works for regular cells, but the merged ones are kept unprotected. Can somebody fix it? I appreciate any help. Thanks!
I found this proven code to Unlock only Empty Cells. I tested in my active sheet that has many vertical and horizontal merged cells. it works for regular cells, but the merged ones are kept unprotected. Can somebody fix it? I appreciate any help. Thanks!
Code:
Sub UnlockEmptyCells()
Application.ScreenUpdating = False
Cells.Locked = True
Selection.SpecialCells(xlCellTypeBlanks).Locked = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Application.ScreenUpdating = True
End Sub