How can i protect a calculated column in a table from being edited but allowing users to add rows?

TonyCrabb 

That is too difficult (we don't know how the user arrived there), but you can do something like this if you really want to irritate your users:

• Right-click the sheet tab.
• Select View Code from the context menu.
• Copy the code listed below into the worksheet module.
• Change Range("F:F") to the column you want to make inaccessible.
• If you ever want to edit the column, type the following in the Immediate window of the Visual Basic Editor and press Enter:
  
  Application.EnableEvents = False
  
  
  
• When you're done, do the same but with
  
  Application.EnableEvents = True
  
  
  
• Don't forget this, otherwise the worksheet won't react to events anymore.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Range("F:F"), Target) Is Nothing Then
        Application.EnableEvents = False
        Beep
        Range("A1").Select
        Application.EnableEvents = True
    End If
End Sub