Is there a way to lock cells after editing an excel sheet that s on sharepoint

Question

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
    Target.Worksheet.Unprotect Password:="saag"
    xRg.Locked = True
    Target.Worksheet.Protect Password:="saag"
End Sub

It doesn't work the same way as you'd expect when someone inputs data on share point.

Answer 1

The Excel Web version (which, based on the screenshot, it appears you're using), does not support VBA. If the user accesses the file in their local Excel application, you might be able to make it work depending on the security settings, but it looks destined to be troublesome.

Instead of using the OnEdit event, you might set up a PowerApp script that would work somewhat similarly. Instead of VBA, you would have to use TypeScript. This video is a decent place to start while transitioning. You can activate TypeScript Recorder, record a few operations, and then utilise the Microsoft documentation to observe how various objects, such as range, interact with one another and their properties (value, locked, etc).