In Microsoft Excel, you can change the document properties of a protected
workbook through a Microsoft Visual Basic for Applications macro, even
though you cannot manually change the document's properties.
↑ Back to the top
To bring up the Document Properties dialog box (where Document is the name of your document), click Properties on the File menu. To protect your workbook, click Protection on the Tools menu, and then click Protect Workbook.
NOTE: When you protect the structure of the workbook, the Properties command on the File menu is no longer available.
↑ Back to the top
For more information about the BuiltinDocumentProperties property, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type builtindocumentproperties property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top