My situation:
I am generating an Excel file from an Access database using VB (Access 2003).

Then I send this file to an outside agency.

They are supposed to update some information and send it back.

I have some formulae in the file (columns as well rows).

I would like to lock and hide the formula.

I can't do that if I don't protect the worksheet.

My problem is that the agency should be able to add rows also.

I tried worksheet.protect method and set allowinsertingrows = true

This allows me to insert rows but not copy/paste and does not copy the
formula from the previous row.

I'll Appreciate any suggestions/help.


Thanks in advance,

bee.