You are correct...I think I found my problem in the area that is unlocked, I
have 3 columns merged together and it gives a different error as to the
merged cells.....the only way I see around this is to redo the area and not
have the merged cells.

On another note though:

I have text boxes that won't allow users to copy and paste into another
worksheet tab. Is there any way around this issue?

"Jim Thomlinson" wrote:

I am a little unclear as to your problem. You can copy and paste into any
unlocked cell on a protected sheet. What you can not do is to copy and paste
into locked cells. Did you want to copy and paste into locked cells. If so
then why bother protecting the sheet as anything can be overwritten with a
copy paste???
--
HTH...

Jim Thomlinson


"LRay67" wrote:

How do I go about letting users utilize the copy and paste function when
worksheet is protected?

Thanks

Linda