T
thesteelmaker
I have a protected worksheet, to stop people deleting thing
unnecessarily. Although some rows need to be deleted occasionally.
I want to delete these rows using a macro that unprotects the sheet
deletes the row that has been selected and then protects the shee
again.
I created the following macro, which works:
Sub DeleteMealItem()
ActiveSheet.Unprotect
Selection.EntireRow.Delete
ActiveSheet.Protect DrawingObjects:=True, Contents:=True
Scenarios:=True
End Sub
But there are some rows in the sheet that i don't want anyone to b
able to delete.
Is there a way to run this so nobody can accidentally delete rows 1 t
8
unnecessarily. Although some rows need to be deleted occasionally.
I want to delete these rows using a macro that unprotects the sheet
deletes the row that has been selected and then protects the shee
again.
I created the following macro, which works:
Sub DeleteMealItem()
ActiveSheet.Unprotect
Selection.EntireRow.Delete
ActiveSheet.Protect DrawingObjects:=True, Contents:=True
Scenarios:=True
End Sub
But there are some rows in the sheet that i don't want anyone to b
able to delete.
Is there a way to run this so nobody can accidentally delete rows 1 t
8