XL: Can Change Protected Document's Properties with VB Macro

ID: Q135504

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows

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 BuiltinDocumentProperties Property, click the Index tab in Microsoft Excel Help, type the following text

   BuiltInDocumentProperties

and then double-click the selected text to go to the "BuiltinDocumentProperties Property" topic.

Additional query words: 7.00 8.00 97 dimmed grey gray greyed disabled out

Keywords          : kbprg kbdta kbdtacode KbVBA 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: January 1, 1999