Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protected cells can be deleted?!
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 Auto_Open() 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", Structu=True, Windows:=False End Sub Any ideas how I can stop locked cells being deleted? Thanks so much in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I retrieve cells which have been permanently deleted | Excel Worksheet Functions | |||
If No is deleted in middle of sequence,Nos alter after deleted No | New Users to Excel | |||
How to protect cells from getting deleted or resized? | Excel Worksheet Functions | |||
Can formulas in cells be made to remain if the data is deleted? | New Users to Excel | |||
#Ref! in cells of row linked to deleted row | Excel Discussion (Misc queries) |