Quote Originally Posted by Dreamboat
No...we'd need it to keep track, like invoice numbers.

I think there should be an entry each for single users and multiple users.

So a single workbook is going to be shared? How are you to determine who's using it - password protection?

PS: Will change my previous code to give protection for the number of times it's opened >>[vba]Option Explicit

Private Sub Workbook_Open()
With Sheets("Sheet1")
    .Unprotect
    Cells.Locked = False
    [A1] = [A1] + 1
    [A1].Locked = True
    .Protect
End With
End Sub