PDA

View Full Version : how to create login id and password



nagavineela
09-23-2010, 10:39 PM
Hi,
Req is to create a form with loginid and password. 2 levels of users - one with admin rights and other with readonly rights.
Please help to progress on this.

Thanks,

xld
09-24-2010, 02:00 AM
Just a simple form with one combox and a textbox with Passwordchar set to *, and two buttons, OK and Cancel. Pre-load the combo with user ids, and check the password on OK. Job done.

nagavineela
09-28-2010, 06:12 AM
Hi XLD,
Thank you. In continuatin with the Login id, when I enter as "User" in the workbook, all sheets in the workbook should goto "ReadOnly" mode while I enter as "admin", should be in edit mode.

Please guide me.

Thanks

Simon Lloyd
09-28-2010, 07:00 AM
Wouldn't just be easier to save the workbook as readonly recommend, password to modify? that way the admin WILL have the password and the lower level user wont!

No VBA needed, no forcing of enabling macro's...........foolproof! (well as foolproof as Excel can be)