PlanMaker · Sharing, safety and accessibility · Intermediate
Protect workbook structure and encrypt a saved file
Separate sheet-structure restrictions from saved-file read protection, then test a disposable encrypted copy without risking the original.
Documentation-reviewed author candidate; no native application execution. · Editorial standards
Quick answer
Use Review > Protection > Workbook protection to restrict changes to the sheet structure. For a password required before opening a saved file, use File > File management > Properties > Protection, choose Read protection, and save. These controls solve different problems; structure protection is not encryption.
Make two disposable copies first
This guide uses paid PlanMaker 2024 on Windows with the English ribbon. It does not certify a cryptographic strength, promise compatibility with every Excel release, or describe a password-recovery service. Use invented data and keep an untouched, unencrypted original before experimenting.
Create a small workbook with two worksheets named Summary and Inputs. On Summary put A1 Practice total and B1 25. On Inputs put A1 Practice value and B1 5. Save the original as Protection original.pmdx.
Use File > Save as to make Structure practice.pmdx for the first test. Later, reopen the untouched original and create Read protection practice.pmdx for the second. Separate copies prevent workbook protection from disabling properties you need to inspect during the encryption exercise.
Passwords are not part of the tutorial’s fixture. Choose your own unique practice password and keep it in your approved password manager. Do not reuse an account password, write it into the workbook, or send it to somebody helping with the exercise. Losing a document password can prevent access to the file; the untouched synthetic original is your recovery path here.
Test workbook structure protection
In Structure practice.pmdx, choose Review > Protection > Workbook protection. The dialog allows an optional password for disabling protection. For a disposable demonstration you may leave it blank, or set a separate practice password if you specifically want to test that boundary. Confirm with OK.
Check that structural actions such as inserting, deleting or hiding worksheets are no longer available. Do not use a real sheet deletion as the first test. An unavailable command or prevented action on the practice copy is enough to establish the intended boundary. Most File > Properties options also become unavailable under this protection.
Now inspect ordinary cell editing. Workbook structure protection is not the same as protecting formula cells. The important negative control is that a workbook can have a stable sheet arrangement while its contents remain editable. If you need locked formulas with permitted input cells, use the separate sheet and cell protection workflow and check its version scope.
Save and reopen Structure practice.pmdx. Confirm both worksheets remain present and the structural restriction is retained. Do not describe this as preventing unauthorized reading: the contents are still visible unless separate read protection was applied.
Apply read protection to a fresh copy
Close the structure test and reopen Protection original.pmdx. Save it under Read protection practice.pmdx before changing protection settings. Confirm the filename so you do not accidentally encrypt the only copy you intended to keep accessible.
- Choose File > File management > Properties.
- Open the Protection tab.
- Choose Read protection, not merely Write protection.
- Enter a unique practice read password. The documented 2024 dialog accepts 4–15 characters and distinguishes uppercase from lowercase.
- Inspect Encryption method and its displayed details. The options are Most compatible and Most secure; use the latter for this isolated modern-version practice unless a separately reviewed compatibility requirement says otherwise.
- Confirm, re-enter the password when requested, and close the dialogs with OK.
- Save the document. The setting does not take effect in the stored file until you save.
Read protection encrypts the saved document and prevents opening it with an incorrect password. Do not generalize that statement into a guarantee against every attacker or into a claim about the confidentiality of unencrypted backups, temporary exports or screenshots.
Verify both denial and successful reopening
Close the file and reopen the exact Read protection practice.pmdx copy. First test a deliberately wrong password once and confirm that the document does not open. Cancel that attempt; do not guess repeatedly or use a password-recovery tool.
Open it again with the correct password. Check Summary!B1=25 and Inputs!B1=5. This positive control confirms you protected the intended file without losing its ordinary content. After opening, change Inputs!B1 from 5 to 6, save, close, and reopen with the correct password. Expect 6. Restore 5 and save if you want the original fixture state.
These are reader verification instructions, not tests performed during authoring. Record only success/failure and the filename in your notes, never the password itself.
Understand the other settings before choosing them
Write protection can allow read-only opening without the write password, so it is not a confidentiality substitute for Read protection. Protection depending on password uses separate read and write passwords to determine whether someone can open only or also save. That added complexity is unnecessary for this practice file.
The encryption-method choice matters particularly for XLS and XLSX compatibility. The manual warns that older Office versions may not open files using the more secure method. Keep the native PMDX working copy, and test any intended recipient/version combination separately using harmless data before distributing a protected real workbook.
Recovery and safe completion
If you cannot reopen the encrypted practice copy, return to the untouched original instead of overwriting it or weakening unrelated security settings. If no password prompt appears, confirm you opened the encrypted copy and saved after changing Properties. If the properties dialog is unavailable, check whether you are still in the structure-protected copy.
Keep or remove the disposable copies according to your normal file-management practice. Deleting a visible duplicate does not prove all backups are gone. No password, native protection state or encryption test was produced for this manuscript.
Official references
See SoftMaker’s workbook protection and document read/write protection and encryption methods.