After opting for sheet protection, how do I unprotect certain ranges of the sheet so others can enter data.

Secondly - I am using this macro to trace changes made on a sheet of a workbook. Is it possible to tweek this macro to cover more than a sheet and have the log also on a "log" sheet.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Rows.Count > 1 Or Target.Columns.Count > 1 Then
For Each thecell In Target
Sheets("Log").Cells(65000, 1).End(xlUp).Offset(1, 0).Value = _
Application.UserName & " changed cell " & Target.Address _
& " to " & thecell.Value & Format(Now, "dd mmm yyyy hh:mm:ss")
Next
Exit Sub
End If

If Target.Value <> PreviousValue Then
Sheets("log").Cells(65000, 1).End(xlUp).Offset(1, 0).Value = _
Application.UserName & " " & Format(Now, "dd mmm yyyy hh:mm:ss") & " changed cell " & Target.Address _
& " from " & PreviousValue & " to " & Target.Value
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
PreviousValue = Target.Value
End Sub