Insert rows in a protected sheet

hi there,

Please help.
I have a shared workbook which has various users at the same time but I want to protect the information in some of the lines.
I want the user to be able to insert new rows anywhere in the workbook and add information.
The one row is blank and the other row is a row to separate the rows from the other information.
So the user need to insert two rows every time. One for information and one as a separater
I know I need to use a macro but I dont know how to write it

Thanks
Aneshree

yes this I know. I want to lock rows where the users dont have acess

sorry. Tell me how.

I tried this but when I insert a row, it inserts the lock row which I dont want.
My file has one locked row and next unlocked. The file only allows inserting of lock rows

Row test.xlsm
I have attached an exmaple.
The grey rows (4,6,8,9,10,12,14) are locked ans should remain the same size.
It is a shared file therefore normally about 8 users are using at the same time.
People should be abled to add two rows (eg 10 & 11). This should be able to be done any where on the sheet.
Row 10 is locked and row 11 unlocked for the person to write in here.

Please help with this

Thanks

hello,

I found this but I am still miss inserting 2 rows with one row being a blocked row and one an unblocked row.

Sub test()
Dim y As Long
Dim x As Long
Application.ScreenUpdating = False
y = InputBox("How many rows")
x = Selection.Rows.Count
ActiveCell.Offset(x).Select
Do Until x = 0
Range(ActiveCell, ActiveCell.Offset(y - 1)).EntireRow.Insert
x = x - 1
ActiveCell.Offset(-1).Select
Loop
Application.ScreenUpdating = True
End Sub


http://www.excelforum.com/excel-prog...-new-post.html

This is were I found the above program. Thanks John

Aneshree,
If I'm following your process, you want to insert two rows, one locked, to be used as a seperator, and one unlocked, to allow the user to enter information. So, for your range of rows after inserting, the pattern should be a row or rows of data, following by an empty row, followed by row or rows of data, followed by an empty row, etc. When your user inserts multiple rows by using the macro above, the pattern changes; now you have row or rows of data, following by an empty row, followed by row or rows of data, followed by an empty row AND an extra empty row. You want to unlock that extra empty row, right? You could put a formula to check for a collection of two empty rows following one another , filter for whichever row of those two you want unlocked, and unlock that one.