The attached file does what you describe. When a workbook opens Excel automatically executes a module named "Auto_Open". I used Auto_Open to display an InputBox and looped until I got a match to one of your user IDs. To keep it clean I used a tab labeled Login for the security check. I also moved your User Ids to Column 1 of the Login Tab and hid the column. Once a correct user ID is entered switch to sheet 2 where work can proceed. If you have any questions let me know. Tom
On Mon, Nov 10, 2008 at 8:55 PM, TERTIUS KOSHY THOMAS < [EMAIL PROTECTED]> wrote: > Hi all, > I need to create a login input box for a workbook.When someone open the > workbook, the login input box must pop up and ask the user to key in the > USER ID. The table of user id is actually in one of the sheets in the same > workbook. > > So the macro can compare with the user input to the userid table and decide > whether need to open the Excel workbook. > > > A sample work book is attached, Sheet 2 has the list of few user ids. > > PS:- No password required. > > Regards, > Tertius. > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
MyWorkbook (WORK).xls
Description: MS-Excel spreadsheet
