Thank you Tom. I think I got what I wanted. Regards, Tertius
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Tom Jeffries Sent: Wednesday, November 12, 2008 6:43 AM To: [email protected] Subject: $$Excel-Macros$$ Re: Macro for Login Page 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 -~----------~----~----~----~------~----~------~--~---
