Shared Excel File - Restricting Edits to Author

NE1Know Well if you are going to open the file in your desktop Excel you can use Macros to do this.  Here is the code you want to have in "ThisWorkbook" sheet:

Private Const Owner = "Your UserName"
Private Const PW = "password"

Private Sub Workbook_BeforeClose(Cancel As Boolean)
        Dim sh As Worksheet
        For Each sh In ThisWorkbook.Sheets
            Call sh.Protect(PW)
        Next

End Sub


Private Sub Workbook_Open()
    If Application.UserName = Owner Then
        Dim sh As Worksheet
        For Each sh In ThisWorkbook.Sheets
            Call sh.Unprotect(PW)
        Next
    End If
End Sub

I have attached a sample sheet and included a button that will tell you your User Name

To get in and edit you click Alt-F11 to open the VB window and then right click 'ThisWorkbook' and then select Show Code:

If you don't see this menu on the left try clicking Ctrl-R

That all said, DO NOT consider this high security by ANY means.