Can Change Protected Document's Properties with VB Macro (135504)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
This article was previously published under Q135504 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 this to be a problem in the Microsoft products
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, click 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 the BuiltinDocumentProperties property, from the Visual Basic Editor, click the
Office Assistant, type builtindocumentproperties, click Search, and
then click to view "BuiltinDocumentProperties Property."
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbbug kbdtacode kbpending kbProgramming KB135504 |
|---|
|