Hi

Got a bit of problem with a shared workbook - not sure if there is a solution for this...

I have a macro which runs which moves data from one worksheet (sheet 1) to another (sheet 2)

When the data goes into sheet 2 the macro is set up so that it creates a new row (eg insort row at row B). The reason for this is so the data being input into sheet two does not paste on top of any existing information, instead it goes straight into the newly created row.

The problem I have is that I want sheet 2 to be protected but to input a new row the macro will not run unless the sheet is unprotected. Now because it is a shared workbook it won't allow me to include protection/unprotection as part of the macro.... anyone know a way around this? or can I set up to paste data below the last completed row of information?

thanks in advance