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)

Please Login or Register  to view this content.

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"

Please Login or Register  to view this content.

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 ?