Inputbox upon opening workbook that checks if the entry is in range

[stinkybink]

I would like to have an inputbox popup when a person opens an excel file that asks for a user ID. if the user ID entered is within a certain range for example 1 - 10, then the workbook opens. If not, it closes. I don't need what is entered to store anywhere. And I don't need a password entered.

Is this possible? I have other sub auto_open codes, so this would be sub auto_open3().

Thank you for your help!