How to allow users to copy protected sheet?

Hello,
I nesed you advice on enabling users to copy values in protected sheet.
I guess it is possible to insert special code that will make possible users to copy values from protected sheet and paste then to another empty one.
Thanks!

Thanks buddy.
I added the 2 lines in the code and it allowed to select. I do not know how I restricted selection.
I did a try to another sheet, just protected a column agains selection and change and then tried to select arange rgar includes that column-no problem.

I have aquestion when I added suggested lines to the macro it change the file in way that it allows user to select a cell without possibility to change. If I want the formula in the cell to be invisible how I can do it?

Not sure precisely what you mean by "invisible". Do you mean that you want the user to be able to see the value in the cell, but not the formula that produces it? You would go to View, then untick Formula Bar. The code to do this is

Please Login or Register  to view this content.

Note that this setting is for the entire application and will affect the views of all open files.

However, also note that if you allow the user to select it, they can copy it, and when they paste it they will be pasting the formula. So you can't allow copying while at the same time prevent them from finding out what the formula is.

Hello,
the problem with enabling users to copy from protected sheet is resolved. Now it appears that they do want to be able to paste at the same sheet.
For example one rowfrom the sheet contains 15 cells. there are many cases where 12 out of those 15 cells have the same value. So users say that for them it will be much easier to copy paste the common values in the next row.
How I can allow them to copy-paste a raw in protected sheet?