Sorry,I am attaching a copy of the login macro with the IDs unhidden. Use any of the names in column 1.
Tom On Wed, Nov 12, 2008 at 11:10 PM, swamy nadan <[EMAIL PROTECTED]>wrote: > 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 -~----------~----~----~----~------~----~------~--~---
Logiin.xls
Description: MS-Excel spreadsheet
