Posts

Showing posts with the label VBA LOGON PAGE BY MS WORD EXCIL

Excel VBA Login Form Rohit

Image
  Excel VBA Login Form It is possible to create a login based user form in excel VBA with all the login id drop-down list, and the password will be shared separately.  At some point in time, you must have got an idea of creating a password-based login user form, which requires the user to pick their user id and enter the password to access the required worksheet. In this article, we will show you how to create a login userform using excel VBA. How to Create a Login User Form? For example, assume you have region-wise sales numbers in different worksheets. We have 4 different zone names, and each zone worksheet has its related data only. Now the idea is to create a login form where the “East” zone sales head should see only “East” zone data, not any other zones, but as an admin, you should see all the zones worksheets. You can download this VBA Login Excel Template here –  VBA Login Excel Template First, we need to insert a sheet name called “Admin.” In this admin sheet, we need to creat