Hi, the simple following code allows me to delete items in a protected sheet. However what I want it to do is delete the entire row, as shifting the cells up causes problems with formulas moving. I am unable to select the row as I have protected against users being able to select locked cells. Is there anyway to adapt the code to "selection, delete entire row.?
Thanks
Chris
Sub Macro7()
'
' Macro7 Macro
'
'
ActiveSheet.Unprotect "password"
Selection.Delete Shift:=xlUp
ActiveSheet.Protect "password", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowInsertingRows:=True, AllowDeletingRows:=True
End Sub
Bookmarks