enabling paste in protected sheet

[cherryt]

Hi all,
I am trying to find a workaround to allow users to paste data into a cell range when the sheet is protected.
The cells are not locked and users can type in data and the workbook is shared. There is no visibility of the standard/formatting/drawing toolbars either.
So far I have the clipboard function to paste the data but I am wondering if there is a simpler way?

Any ideas?

Thanks in advance.

[dilipandey]

Hi Cherryt,

If the cells are not locked then protection has no affect on them.
are you able to do ctrl + V ?
what options you checked while protecting the sheet ?



Regards,
DILIPandey
<click on below * if this helps>

[cherryt]

Nope can't do ctrl +V either.
All the options are selected.

[dilipandey]

Then it means that your cells are locked.
but you said

The cells are not locked

.. can you check?

I just tried this -> unlocked all the cells and protected the sheet 1. Now typed a text in sheet 2 and copied that, came back to sheet 1 and done ctrl + V .. found no problems


Regards,
DILIPandey
<click on below * if this helps>

[cherryt]

Yes the cells I want to paste into are not locked.

[dilipandey]

can you upload the workbook after removing the sensitive information ? thanks.


Regards,
DILIPandey
<click on below * if this helps>

[cherryt]

unfortunately I can't upload any files. I am pasting data from another workbook/file it is not in the same file. I don't have the workbook protected just the sheets.

[dilipandey]

but I tried as mentioned in post #4 and found no issues.



Regards,
DILIPandey
<click on below * if this helps>

[cherryt]

Thanks but I can't seem to get around it. It did paste when it was from a word doc but not from another excel file..strange..
thanks once again.

[dilipandey]

I am not sure unless I see the sample workbook



Regards,
DILIPandey
<click on below * if this helps>