Insertig/deleting rows in VBA

[Sebyq]

Hi guys,

I was wondering if anyone could help me with this? I would like a macro to block users of a shared spreadsheet from inserting/deleting rows without protecting it. So in essence they should be able to amend anything on it apart from inserting or deleting rows? Could anyone help me out on this? I looked online for the last 2 days nd I can`t find anything?

Many thanks!

 

[Michael M]

I think you will have to protect the sheet to do that !
You will still be able to carry out almost ALL other functions, except delete AND Inserting rows
you will also need to Unlock ALL cells first
Select all cells>>Rclick>>Format>Protection>>uncheck Locked
Then paste this is the Sheet Module that it applies to !

Private Sub WorkSheet_Activate()
    ActiveSheet.Protect AllowInsertingRows:=False, AllowDeletingRows:=False
End Sub