Workbook.ProtectSharingEx Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Saves the workbook and protects it for sharing.
public void ProtectSharingEx (object Filename, object Password, object WriteResPassword, object ReadOnlyRecommended, object CreateBackup, object SharingPassword, object FileFormat);abstract member ProtectSharingEx : obj * obj * obj * obj * obj * obj * obj -> unitPublic Sub ProtectSharingEx (Optional Filename As Object, Optional Password As Object, Optional WriteResPassword As Object, Optional ReadOnlyRecommended As Object, Optional CreateBackup As Object, Optional SharingPassword As Object, Optional FileFormat As Object)Parameters
- Filename
- Object
The name of the saved file. You can include a full path; if you do not, Microsoft Office Excel saves the file in the current folder.
- Password
- Object
A case-sensitive password for the workbook. If this argument is omitted, you can unprotect the workbook without using a password. Otherwise, you must specify the password to unprotect the workbook.
- WriteResPassword
- Object
The write-reservation password for this file. If a file is saved with the password and the password is not supplied when the file is opened, the file is opened read-only.
- ReadOnlyRecommended
- Object
true to display a message when the file is opened, recommending that the file be opened read-only.
- CreateBackup
- Object
true to create a backup file.
- SharingPassword
- Object
The password to be used to protect the file for sharing.
- FileFormat
- Object
A string that indicates the file format.
Remarks
Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords do not mix these elements. For example, "Y6dh!et5" is a strong password, but "House27" is a weak password. Use a strong password that you can remember so that you do not have to write it down.
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.