On 14 May, 20:11, Bee wrote:
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.

Bee,

Have you thought about block filling enough formulas to cover
If the agency are simply enterring data but need to see the results of
the formulas this should work OK.

Example,

Access produces 15 records, but you populate formulae to 100 rows,
allowing the Agency up to 85 rows to enter source data for new
records?

My only other thought is to turn the workbook into a small application
and use macro's userforms etc to allow the agency to update.

Anthony