Microsoft KB Archive/58232

From BetaArchive Wiki

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.