Hi, Tom
let me know the user name to open.. Regards M.A. Swaminadane On Wed, Nov 12, 2008 at 4:13 AM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
