B
Bee
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.
Thank you in advance.
bee.
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.
Thank you in advance.
bee.