Security, Protection, and VBA Projects

Microsoft Office 2000 applications allow password protection of a document saved to a native binary format file. However, since HTML is a plain text file format, a password is ineffective protection since the page can be opened in one of many commonly available text editors. If password protection is required, the use of binary format files is recommended.

Office applications also allow you to specify a document as read-only to prevent the document from being changed when it is opened. When the document is saved as a Web page, the read-only status is saved using the ReadOnlyRecommended subelement of the OfficeDocumentSettings element.

In Microsoft Word, the DocumentProtection element specifies the protection level of a document and its individual sections. If you specify a password for a level of protection and save the document as a Web page, the protection level is preserved but the document is no longer password-protected.

In Microsoft Excel, the ProtectStructure and ProtectWindows elements specify workbook-level protection, while the ProtectContents, ProtectObjects, and ProtectScenarios elements specify worksheet-level protection. Note that a workbook saved as a Web page cannot be protected and shared. Cell-level protection is specified using CSS mso-protection styles within the cell elements of the HTML table that represents the worksheet. A cell can be locked, unlocked, hidden, or visible. If you specify a password for a level of protection and save the document as a Web page, the protection level is preserved but the document is no longer password-protected.

Visual Basic for Applications (VBA) projects, project properties and settings, references, window states, password, and digital signatures are stored in the editdata.mso file in binary format. Password protection of VBA projects is retained when the document is saved as a Web page and opened in an Office application. To learn where the editdata.mso file is stored, see the Folder and File Names topic.