D
DannyS
I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!
My macro is as follows:
Sub Autpen()
Dim wks As Worksheet
For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks
ActiveWorkbook.Protect Password:="Password", Structure:=True, Windows:=False
End Sub
Any ideas how I can stop locked cells being deleted?
Thanks so much in advance!
works well whenever a user attempts to overwrite a locked cell. However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!
My macro is as follows:
Sub Autpen()
Dim wks As Worksheet
For Each wks In Worksheets
With wks
.Protect Password:="Password", userinterfaceonly:=True
.EnableOutlining = True
End With
Next wks
ActiveWorkbook.Protect Password:="Password", Structure:=True, Windows:=False
End Sub
Any ideas how I can stop locked cells being deleted?
Thanks so much in advance!