Microsoft KB Archive/23763

Externally Copying Parts of Password Protected Sheets PSS ID Number: Q23763 Article last modified on 07-29-1987 PSS database name: D_MPlan

3.0 3.01 3.02

MS-DOS

Question: I want to protect my spreadsheet with a password, but I want to be able to Xternally Copy one area of it without having to always enter the password. In other words, is there a way to keep part of a password protected spreadsheet open for access without the password?

Response: Yes. If you give the area that you wish to remain open the name “PUBLIC”, you will be able to Xternally Copy information from that area of the spreadsheet.

Copyright Microsoft Corporation 1987.