Is it possible to lock cells in an Excel sheet on Sharepoint once a user enters data? On Excel, I can lock the cells, but not on Sharepoint. Basically, when you enter data into the Excel app, it doesn't lock cells the way it does on Sharepoint.
Is there work for this? I've already tried the VBA code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim xRg As Range
On Error Resume Next
Set xRg = Intersect(Range("A1:G800"), Target)
If xRg Is Nothing Then Exit Sub
xRg.Locked = True
It doesn't work the same way as you'd expect when someone inputs data on share point.