If you want to make your Microsoft Excel file password protected, there are a few ways to do it. One way is by using Classic Menu for Excel 2007/2010/2013/2016/2019. This software provides a classic interface that allows you to easily navigate and protect your Excel files.

To start, open your Excel document and switch to the 'Menus' tab. From there, click on 'Protect Sheet' or 'Protect Workbook' by clicking their buttons. You will then be prompted to enter a password. If you don't have one, you can create one by going to Create your first SQL database.

Once you have entered the password, a dialog box will pop up asking you to confirm it. Click on 'OK' to proceed.

Now that your Excel file is protected, you can share it with others and be confident that they won't be able to access its contents without entering the correct password.

If you want to connect to a password-protected Excel file, you can do so by using VBA code. Here's an example:

```vb

Dim protection As String

protection = '123'

Worksheets.Protect protection

```

This code will protect your Excel file and require users to enter the correct password before they can access its contents.

It's also possible to set up an event handler in the ThisWorkbook VBA module of your workbook to protect all sheets when opened, then get the user ID and unprotect their sheet(s). Here's an example:

```vb

Private Sub Workbook_Open()

Dim worksheets As Worksheets

Set worksheets = ThisWorkbook.Worksheets

For Each worksheet In worksheets

worksheet.Protect '', True, True, True, True, True, True

Next worksheet

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Parent.IsVisible Then

If Target.HasFormula Then

MsgBox 'This cell contains a formula.'

Else

MsgBox 'This cell does not contain a formula.'

End If

End Sub

```

In this example, when the workbook is opened, all sheets are protected. When a user selects a sheet, an event handler is triggered that checks if the selected cell contains a formula. If it does, a message box will pop up indicating that the cell contains a formula.

Overall, protecting your Excel files with passwords can help you keep your data secure and prevent unauthorized access.

How to make password protected excel