Excel: Moving the Window of a Locked Document Without Password

ID: Q59622

The information in this article applies to:

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

To enable the manipulation of the windows of a protected Microsoft Excel document without using the password, do the following:

From the Options menu, choose Protect Document.

Select the Contents box and leave the Windows box blank.

To enable this manipulation through a macro, use the following command:


   =PROTECT.DOCUMENT(TRUE,FALSE,"password")

The first argument (TRUE) represents the contents' protection and the second argument (FALSE) represents the windows' protection.

These procedures allow the windows of protected documents to be manipulated without using the password.

Additional query words: 2.20 3.0 4.00

Keywords :
Version :
Platform :
Issue type :