Microsoft KB Archive/58232

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Excel: Password in PROTECT.DOCUMENT() Returns Macro Error



The information in this article applies to:


  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0



PROTECT.DOCUMENT() is a Microsoft Excel macro command that allows you to protect a document or chart with or without a password.

To protect a document with a password, the password argument must be surrounded by double quotation marks (""). If there are no quotation marks around the password, Excel returns a macro error. This occurs because any text not surrounded by quotation marks that is passed as an argument to any Excel function is assumed to be a defined name.

Additional query words: 2.20 3.0 4.00

Keywords :
Version :
Platform :
Issue type :
Technology :


Last Reviewed: March 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.