In this article we will learn about how to protect excel file with login ID and Password. This method will help you to protect your Excel file form unauthorized access to your file. we will learn details about how to protect it. so that no one will be able access the file without login ID and password.

How to set up  ID and Password

Open Excel file which you want to protect. Then go to "Developer Tab", under that click on Visual Basic. So that Microsoft visual Basic application will open, click on "Insert Userform Tab "

    Picture below showing User-form Tab
ToolBoxThen draw the Shape which are require to create the login ID and password using tool box available
Use different tool
to draw the box.

Creating a login Button using a tool called command box. Then double click on login button to open the code box where we need to write down some codes. so click here or click on this link in order to download the code from notepad.  https://drive.google.com/open?id=1mrk5KYbtVLxZDXWUEogMuD2x_JQuJjrkeer 
After downloading it copy the code starting from " Dim to End If " and paste it (heading should be UserForm1 and under command button) between Private Sub and End sub. If you go through code you will find "pgallinone" as username, so change that word pgallinone with your username and there only you will find password as some number change those number with your password. Now click on workbook so that Workbook code box will open, just type here UserForm1 .show so that the userform1 will be display as you open your excel file. 

        Now in the last we need to enter a code which is in our notepad just copy it. Starting from private sub till end and paste it in userform1 code below "end sub" code and after pasting the code type "End Sub" in the end of code. so then our id and password box is ready. You can watch my video on the same for detail tutorial click on below link