open a message window when excel file is opened with a function button

Hi,
I am looking for help for the following:

Whenever the excel file is opened, it opens a small window stating ' please print your email address' with a click button 'Enter'

When the button is pressed, the window disappears , but the email address typed is stored in sheet 10 in the next available row with date and time populated from

Please Login or Register  to view this content.

This will allow to keep track of who has used excel file , when and what time?

Is it possible?

Any help please

Regards

Hi,
Sorry. Cant see the attached file.
Regs

Hi,
It is exactly what I was looking for.
Fantastic help.
Really appreciate.
Regs

Hi Apology to reopen this one because I am making a mistake.

I created a sheet called 'Who' and amended the code as follows:

Please Login or Register  to view this content.

It does everything as you have explained, but records the email and time in sheet1 whereas I want it to be in sheet called 'Who'
Please help
Regs

Hi,
The code is great. When I use it it records the email and date/time in sheet1, but I want it to be recorded in sheet called'Who'.... it is now sheet15... I have named it as 'Who'.
I have changed the sheet name back to 'sheet15 ' and it works fine.
small mistake on my part.
Your code is fantastic. I dont have words to thank you. This is now fully closed thread.
Regs.