Password Protect Multiple Excel files

You can use the below vba code (posted here by Justin Hampton) to add a password to multiple Excel files in a single folder.

Open a blank workbook, and press ALT + F11. Enter the below visual basic code in a new module, by right clicking on the workbook name in the Project List, and selecting Insert . . . Module

Specify the directory containing your files on the line beginning 'folderPath'.

Enter a password on the line beginning 'Filename:=Application.'.

Run the macro and the files will be protected. When they are next opened, the user will be prompted to enter a password.

As always, I tested this technique tonight using test data, and confirmed that it works.

Public Sub addPassword()
    Dim FSO As Object
    Dim folder As Object, subfolder As Object
    Dim wb As Object
    
    Set FSO = CreateObject("Scripting.FileSystemObject")
    'update the path where the files are saved below
    folderPath = "C:\foofolder\test4"
    Set folder = FSO.GetFolder(folderPath)
    
    With Application
        .DisplayAlerts = False
        .ScreenUpdating = False
        .EnableEvents = False
        .AskToUpdateLinks = False
    End With
        
    For Each wb In folder.Files
        If Right(wb.Name, 3) = "xls" Or Right(wb.Name, 4) = "xlsx" Or Right(wb.Name, 4) = "xlsm" Then
            Set masterWB = Workbooks.Open(wb)
            'update "yourpassword" to the password you would like to use, below
            ActiveWorkbook.SaveAs Filename:=Application.ActiveWorkbook.FullName, Password:="DogCat2020"
            ActiveWorkbook.Close True
        End If
    Next
    For Each subfolder In folder.SubFolders
        For Each wb In subfolder.Files
            If Right(wb.Name, 3) = "xls" Or Right(wb.Name, 4) = "xlsx" Or Right(wb.Name, 4) = "xlsm" Then
                Set masterWB = Workbooks.Open(wb)
                'update "yourpassword" to the password you would like to use, below
                ActiveWorkbook.SaveAs Filename:=Application.ActiveWorkbook.FullName, Password:="yourpassword"
                ActiveWorkbook.Close True
            End If
        Next
    Next
    With Application
        .DisplayAlerts = True
        .ScreenUpdating = True
        .EnableEvents = True
        .AskToUpdateLinks = True
    End With
End Sub

Add Password Protection to Multiple PDF Files

FoxtIt Phantom allows users to create actions that will bulk process multiple PDF files, in a very similar fashion to how actions are created in Adobe Acrobat. It's quite easy to set up an action to password protect multiple PDF files. Follow these steps:

1. Go to File . . . Action Wizard . . . Create New Action

2. In the Protect menu, select Secure Document . . . Password Protect, and add this to the action.

3. From the File menu select Main Panel . . . Save and add that to the action.

4. Under Password Protect click Specify Settings and enter a password. You'll also see an option to select a particular kind of encryption.

5. Be sure to uncheck the option to prompt user for both the Password Protect and Save steps in the action.

6. After the action is saved, you can then run it by going back to File . . . Action Wizard . . . Run Action. You'll see a list of the actions that have been created.

7. After the action is run, a user will be prompted to enter a password each time a PDF is opened.

Client Isolation

A setting called 'client isolation' on a router will prevent a computer that connects to a wifi network from accessing computers (and other devices) that are on the same network with wired connections. This is very useful if you plan on having visitors use a network set-up for the use of attorneys from your firm.

The client isolation setting will also prevent two devices connected to the network via wifi from connecting with one another.

Client isolation (also known as wireless isolation) differs from guest wifi networks which involve an entirely separate access point. Client isolation uses firewalls to restrict visitors to connecting to the internet.