Workbook.ProtectSharing (Excel)

Saves the workbook and protects it for sharing.

Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements.

ProtectSharing (Filename, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, SharingPassword, FileFormat)

ActiveWorkbook.ProtectSharing

Arguments

Optional arguments

The following arguments are optional

Filename (String) - A string indicating the name of the saved file. You can include a full path; if you don't, Microsoft Excel saves the file in the current folder.

Password (String) - A case-sensitive string indicating the protection password to be given to the file. Should be no longer than 15 characters.

WriteResPassword - A string indicating the write-reservation password for this file. If a file is saved with the password and the password isn't supplied when the file is opened, the file is opened read-only

ReadOnlyRecommended (Boolean) - True to display a message when the file is opened, recommending that the file be opened read-only.

CreateBackup (Boolean) - True to create a backup file.

SharingPassword - A string indicating the password to be used to protect the file for sharing

FileFormat - A string indicating the file format