protect cells

[Souris]

I would like to protect some cells to avoid user to modify information.

My copy method fails, if I use protect and unprotect.

I use Protection.AllowEditRanges.Add to write information on the cells using
VBA.

It seems VBA can not copy data in to the cellls which protect and unprotect
or AllowEdirRanges.

Am I right?
If I am wrong please advise me,
Any information is great appreciated,

[Nigel]

You are right, you must unprotect before you copy, you can then re-protect
after.

--
Cheers
Nigel



"Souris" <[email protected]> wrote in message
news:[email protected]...
> I would like to protect some cells to avoid user to modify information.
>
> My copy method fails, if I use protect and unprotect.
>
> I use Protection.AllowEditRanges.Add to write information on the cells
using
> VBA.
>
> It seems VBA can not copy data in to the cellls which protect and
unprotect
> or AllowEdirRanges.
>
> Am I right?
> If I am wrong please advise me,
> Any information is great appreciated,
>

[Souris]

It seems that AllowEditRanges does not allow copy either.

I need delete AllowEditRange and unprotect spreadsheet to do copy method.



"Nigel" wrote:

> You are right, you must unprotect before you copy, you can then re-protect
> after.
>
> --
> Cheers
> Nigel
>
>
>
> "Souris" <[email protected]> wrote in message
> news:[email protected]...
> > I would like to protect some cells to avoid user to modify information.
> >
> > My copy method fails, if I use protect and unprotect.
> >
> > I use Protection.AllowEditRanges.Add to write information on the cells
> using
> > VBA.
> >
> > It seems VBA can not copy data in to the cellls which protect and
> unprotect
> > or AllowEdirRanges.
> >
> > Am I right?
> > If I am wrong please advise me,
> > Any information is great appreciated,
> >
>
>
>