Inputbox with file is opened with input data verified with table

Hi all,
I am trying to achieve is:
- when file is opened, input box is displayed
-It says to type your number and click OK
-It then matches the number inputted by user with related application user name
-if both match then file is opened
-or else a warning flashes that number is wrong
-It continues till user inputes the correct number

e.g. My number is 1234 and applicationusername is ABCD
when I open file, the applicationusername is already known as ABCD
then I type 0000 which is incorrect as the matched number should be 1234
this triggers warning till I input correct number

How to do this ???
Any help please.
Kind regards


Code I use us as follows:
Thisworkbook

Please Login or Register  to view this content.

Module

Please Login or Register  to view this content.

Also can we change colour of the inputbox??
Thanks

Hi Izandol,
Wow
A great solution though.
Fantastic work.
Thanks again.
If I add the computername to code , will it be possible to add to this code which will again match machine name to its location, and then add it where "Log-in" comes, in this code Please.
Machine name may be XCRIP2233 and location can be XYZ. I want XYZ to be populated in the input box rather than machine name

Please Login or Register  to view this content.

Again thanks for your help.
I am closing this thread as original question is fully solved.
Please let me know if you want me to post this question in new thread.

Thanks again.

OK Sir.
Apology
I will post it and send you a link
My words will fall short to thank you.
Kind regards

Hi,
I have posted a new thread
Please have a look.
attached File explains everything
Many thanks
kind regards
http://www.excelforum.com/excel-prog...ml#post3524694

Hi Izandol,
Apology to re-open this one.
When I click cancel button on the inputbox, it allows the file to be opened.
By any way can we either disable 'cancel ' button on inputbox

or

code it to shut file if cancel button is clicked at any time

Please help
Kind regards

Great work my friend
God Bless