Record date of opening a workbook, together with user name

Hi! This is first my post here!

I am looking to create a template workbook for user acceptance testing (UAT) where I wish to have autopopulated on separate tables of the sheet (please see attached),

1. the name of the first person (Tester A) opening the sheet and the date+time it was opened by them.
2. the names and date+time of each person opening (Testers and Users) the sheet at any point of time.

Is this possible? How does one go about it?

P.S.: I have no idea about Excel programming as it is rarely, if at all, part of my work/student life, but I shall try my best. I'd appreciate any easier way to go about this that does not involve programming.

Cheers!

APPEND: I found this code in the forum here, but I can't get it to work due to the following error: (Error 9: Subscript Out Of Range)

Option Explicit
Private iNextRow As Long
Const HIDDEN_SHEET As String = "Sheet3"

Private Sub Workbook_Open()
With Worksheets(HIDDEN_SHEET)
.Range("A1").Value = Environ("UserName")
.Range("B1").Value = Format(Date + Time, _
"dd mmm yyyy hh:mm:ss")
End With
iNextRow = 2

End Sub

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Range)
On Error GoTo wb_exit
Application.EnableEvents = False
If Sh.Name <> HIDDEN_SHEET Then
With Worksheets(HIDDEN_SHEET)
.Range("A" & iNextRow).Value = Environ("UserName")
.Range("B" & iNextRow).Value = Format(Date + Time, _
"dd mmm yyyy hh:mm:ss")
End With
End If

wb_exit:
Application.EnableEvents = True
End Sub

Hello lost_astronaut

One thing that you have to take into account is that the user should be forced to open workbook with macro's enabled.
For if the user opens workbook without macro's enabled you will not get a macro recording you login information.

ONE WAY TO ACHIEVE THIS ...
- on closing have macro hide and lock all sheets except for a "splash sheet"
- the "splash sheet " in big bold print tells them to open book with macros enabled
- the "on open" macro trigger , if macros are enabled, macro is triggered automatically to hide splash sheet and unhide / unprotect all other sheets.
- if user does not enable macros on open only sees splash sheet ELSE , if enabled sees all sheets but flash sheet


Code to "forced to open workbook with macro's enabled"

Const SPLASH_SHEET_NAME = "DisabledNotice"

Private Sub Workbook_Open()
   changeSheetState xlSheetVeryHidden, xlSheetVisible
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
   changeSheetState xlSheetVisible, xlSheetVeryHidden
End Sub

Private Sub changeSheetState(flashSheetState, otherSheetsState)
    Dim wksh As Worksheet
    With Application
    .ScreenUpdating = False
    Sheets(SPLASH_SHEET_NAME).Visible = xlSheetVisible
    For Each wksh In ThisWorkbook.Sheets
        If wksh.name <> SPLASH_SHEET_NAME Then
            wksh.Visible = otherSheetsState
        End If
    Next wksh
    Sheets(SPLASH_SHEET_NAME).Visible = flashSheetState
    .ScreenUpdating = True
    End With
End Sub

if this has helped please consider clicking "add reputation" , thx

Hello lost_astronaut:
I have a couple questions for you .

the names and date+time of each person opening

QUESTION 1
You have two types of people opening the workbook ; Testers and users.
My question is what is it about a person that determines which group they belong to .
More specifically how would the macro , that enters their name/date into the table, know which group they belong to ?

FOR EXAMPLE:
If the macro that logs them into the table is triggered by opening the workbook , how would the macro know if they are a user or a tester ?
Do you want the macro to popup a msgbox that asks which they are a tester or user ?

QUESTION 2
Why do you need 2 tables when the "UAT template" table will only have a single record... and that single record is always going to be the first record in the "Documents Open by" table ?
When you want to know who the first tester is (aka Tester A) can't you just refer to first row of "Documents Opened by" table ?