Microsoft KB Archive/205883

= 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  Properties dialog box (where   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.

