Hi All,

I am currently trying to create a spreadsheet at work, and i only want to allow the end users to enter data in certain cells. Therefore i have locked and protected the cells that contain formulas and will generate sums as the user enters data.

However one thing i would like to add (if possible) is adding a new row in the spreadsheet when it is locked (i assume this would be done via a macro but i am very much a novice). But i want the new row to copy the layout and more importantly the formulas from the rows above/below so the user can still add the data and it automatically produces the answers in the locked cells as all previous rows do.

also would this be possible when the sheet is protected, by the user simply clicking insert? or double clicking etc.? or would they have to run the macro?

i have attached my spreadsheet to help explain what im trying to do - the sheets are to be protected without a password.CVR & Forecasting Rev HARRY.xls

Thank you very much in advance for helping me out, i look forward to seeing your replies!

Harry