Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools

7 Comments

  1. Dear Ravindra,

    You’re welcome!
    In the cmdOK_Click() procedure you can insert a query from a database or, if you want to keep it static, you can add more users and passwords in this procedure:
    if strconv(trim(……..)=”GUEST” or strconv(trim(…..)=”GUEST2″ then
    ………………..
    if strconv(trim(……)=”PA$$” or strconv(trim(……..)=”PA$$2″ then

    This is it!
    Kind regards!

    • do you have macros enabled? does the login form appear?
      use credentials guest and pa$$

      to view the VBA code use PA$$

  2. Hello sir, it is very usefull. I want to change user id, how can we do that. I also couldn’t understand where to paste multiple user login codes. Please help

  3. Okk. I found it. But it also allow “Guest1” with the Password of “Guest2” and vice versa. Any solution?

    • Hi Rajat,

      Sorry for the late reply.
      I amended and replaced the xlsm file, so now a list of users and passwords could be accommodated inside sheet Usr. Please open the VBA editor (PA$$) and set the visible attribute to Visible. When you save the file, this sheet will get VeryHidden so that it will not be available for anyone.
      Regards!

Leave a Comment

Your email address will not be published. Required fields are marked *

It is main inner container footer text