Who to Lock your MS Excel File

HOME PAGE 

  UPSC :-Civil Service Previous year Exam Paper PDF          UPSC Prelims 2021 Paper Analysis I Indian Polity             UPSC Prelims 2021 Paper Analysis I Science & Technology                 UPSC Prelims 2021 Paper Analysis I Geography             IAS/PCS Essay Book  Paper Notice and syllabus :PET EXAMINATION SYLLABUS            PET QUESTION PAPER                 SINDHU GHATI SABHYATA                         GST                     B.Ed Second Year Book -2021                            DIGITAL INDIA                    CHILD LABOUR IN INDIA  Competitive Book :- GK/GS Book 2021                              All Competitive Maths Book                    All Competitive Resigning Book            Important Project :-  Who to Lock your MS Excel File         Tailly Erp 9 Accountig Tips      Visual Studio C # Project      Tally Erp9 Account Feature      Microsoft  Excel VBA Project                    who to  apply mathematical Formula in ms excel user form                   MS Excel UserForm Save And Edit Button Part-1 Module          MS Excel UserForm Save And Edit Button Part-2 Module          Use Vlookup Formula in MS Excel UserForm     Purvanchal University Book :  Purvanchal University Sure Series Book pdf Youtube Class Note :    UP B.Ed Science Entrance Book 2022 Note         Maths Class Note

                                            MS Excel File :-

                                   If you wont to lock your ms excel file and protect the data in MS Excel in MS Excel Sheet. There are two method to lock your MS Excel Sheet data data file. 

 1. Directly Lock the MS Excel data sheet .

 2. Make a login form and set your Id and Password .

1. Directly Lock :-

                               MS Excel provide the two method to lock your data in MS Excel sheet and Workbook . If you wont to apply it then go to the Review , Review Changes option provided the Protection of MS Excel data and data Sheet.

I)  Protect Sheet 

II) Protect Workbook

I) Protect Sheet:-

                           When you select the protect sheet then ms excel provide a new selection form and selection option is open is the form . Selection option is it.

*Format cell

*Format columns

*Format rows

*Insert columns

*Insert rows

*Insert hyperlinks

*Delete columns 

*Deletes rows

*Sort 

*Use Auto Filter

*Use Pivot Table Reports

*Edit objects

*Edit scenarios

                         what type of need to lock you MS Excel sheet to selected the option in given the password . 

                          If you set the password then the password is active in this Sheet.

II) Protect Workbook :-

                                    This is the great feature of MS Excel . Protect Workbook option is provided the Project Structure and Windows . This option is Lock your total file who make in MS Excel.

2. Using MS Excel VBA :-

                                                  In this method MS Excel VBA Provided a User From , Who design by himself. Like Using the Textbox and Label.

                  If you wont to make a Login Form Look at the bellow  and write the written code.

              

                           TextBox1 = TextBoxUserId

                           TextBox2 = TextBoxPassword

                          CommandButton1 = CommandButtonLogin

Click the Login Command button and Write the code Bellow.

Private Sub CommandButtonLogin_Click()

If Me.TextBoxUserId.Value = "NARSINGH123456@" And Me.TextBoxPassword.Value = "NARSINGHYADAVp" Then

Application.Visible = True

MsgBox " Welcome Narsingh yadav"

Else

Me.TextBoxUserId.Value = ""

Me.TextBoxPassword.Value = ""

MsgBox " Warning ! For you "

End If

End Sub

 Note :-

                If  you wont to any other person can't open your login from then Write the code bellow but this code is only written by Default open the login form .

Private Sub Workbook_Activate()

Application.Visible = False

UserFormSale.Show

End Sub

Some other topics:-

1. TextBox change Module 

2. TextBox Enter Module 

3. MS Excel UserForm Save And Edit Module Part-1 

4. MS Excel UserForm Save And Edit Module Part-2 

5.