XL98: Can Change Protected Document's Properties with VB Macro
Article ID: 205883
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q205883
SYMPTOMS
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 change the document properties manually.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
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, point to Protection on the Tools menu, and then click Protect Workbook. When you protect the structure of the workbook, the Properties command on the File menu becomes unavailable.
REFERENCES
For more information about BuiltinDocumentProperties Property, from the Visual Basic Editor, click the
Office Assistant, type builtindocumentproperties, click Search, and
then click to view "BuiltinDocumentProperties Property."
Additional query words: 8.00 dimmed grey gray greyed disabled out XL98
Keywords: kbbug kbprogramming kbpending kbcode KB205883