Workbook.ProtectSharingEx Method (Object, Object, Object, Object, Object, Object, Object)


Saves the workbook and protects it for sharing.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

void ProtectSharingEx(
	object Filename,
	object Password,
	object WriteResPassword,
	object ReadOnlyRecommended,
	object CreateBackup,
	object SharingPassword,
	object FileFormat


Type: System.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.

Type: System.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.

Type: System.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.

Type: System.Object

true to display a message when the file is opened, recommending that the file be opened read-only.

Type: System.Object

true to create a backup file.

Type: System.Object

The password to be used to protect the file for sharing.

Type: System.Object

A string that indicates the file format.

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.

For information on optional parameters, see Optional Parameters in Office Solutions.

Return to top