Forum Discussion
Solved
How can I disable the Warning Pop ups on protected cells to make the document more user friendly
How can I disable the Warning Pop ups on protected cells to make the document more user friendly? All celled are protected and formulas hidden. Each time the protected cell is clicked on the warn...
gymsmalta If you can use a bit of VBA, you can prevent that like so:
- Right-click the sheet tab and choose "View Code"
- Paste this code into the window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Cells(1, 1).Locked Then Cancel = True End SubSave-as your file to the xlsm type (Excel workbook with macro's)
gymsmalta If you can use a bit of VBA, you can prevent that like so:
- Right-click the sheet tab and choose "View Code"
- Paste this code into the window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Cells(1, 1).Locked Then Cancel = True
End Sub
Save-as your file to the xlsm type (Excel workbook with macro's)
It worked perfectly many thanks, saved me hours and hours! - Thanks