how to make cell/range read only and allow copy content

[davidmyers]

Hi,
I have some columns I'd like to make read only - can't edit content - but content can be selected to copy,
how do I do this?

Thanks for any help
David

 

[lhartono]

1. You can protect the whole sheet, by right click on the sheet names tab, select protect sheet.
in context Protection Menu you can checked other options you needed, like dis/allow format, dis/allow delete, dis/allow insert, dis/allow sort.
You can protect the sheet with password or leave it empty.

2. If want to protect the whole sheet but left some range unprotected to allow changes,
first select the range that allow to edit, right click, choose "Format Cells...", select "Protection" tab, unchecked "Locked",
then do #1 .

3. Protection menu also available In Excel Ribbon, goto Review, "Protect Sheet".

 

[davidmyers]

Thanks Ihartono, This seems to work - I was doing the opposite first protecting the sheet then unprotecting the column.
But now I have another problem, there's a UserForm with a listbox connected to one of the not protected columns which
is activated with the following code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Application.Intersect(Target, Range("N2:N756")) Is Nothing Then
        Cancel = True
        UserForm1.Show
    End If
End Sub

Before following your instruction above it was working ok, now when I double click in the column nothing happens, Any Ideas?

Thanks
David

 

[My Aswer Is This]

Did you un protect column "N"

Thanks Ihartono, This seems to work - I was doing the opposite first protecting the sheet then unprotecting the column.
But now I have another problem, there's a UserForm with a listbox connected to one of the not protected columns which
is activated with the following code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Application.Intersect(Target, Range("N2:N756")) Is Nothing Then
        Cancel = True
        UserForm1.Show
    End If
End Sub

Before following your instruction above it was working ok, now when I double click in the column nothing happens, Any Ideas?

Thanks
David

 

[davidmyers]

Hi Ihartono,
I tried unprotecting the whole worksheet to see if that was the problem, but the userform is still not showing so I have no idea what the problem is!

???
David

 

[davidmyers]

Hi, All's working ok - got the right sequence of events in the end - Thanks for your help.

David