×
inglise
Palume vabandust. See artikkel pole teie keeles saadaval.

Require a password to open or modify a workbook

Maci jaoks ette nähtud Microsoft 365 rakendus Excel, Excel 2019 for Mac, Excel 2016 Mac-arvuti jaoks

You can help prevent unauthorized users from opening or modifying a workbook file, even if they have permission to open it.

Caution: When you create a password for a workbook, write down the password and keep it in a secure place. If you lose the password, you can't open or gain access to the password-protected workbook.

  1. Open the sheet or workbook that you want to protect.

  2. On the Review tab, click Protect Sheet or Protect Workbook.

    Password protection buttons

  3. In the Password box, type a password, and in the Verify box, type the password again.

  4. Choose any other protection options you want and click OK.

  5. Click Save.

    Tip: To remove a password, click Unprotect Sheet or Protect Workbook and enter the password.

Require a password to open a workbook

  1. Open the workbook that you want to protect.

  2. On the Review tab, under Protection, click Passwords.

    Review tab, Protection group

  3. In the Password to open box, type a password, and then click OK.

  4. In the Confirm Password dialog box, type the password again, and then click OK.

  5. Click Save  Save button .

    Tip: To remove a password, select all contents in the Password to open box, and then press DELETE .

Require a password to modify a workbook

You can add a password so that only authorized users can make changes to a workbook. Users who are not authorized can still open the workbook and then save it by using a different file name.

Note: Unlike workbook element protection, which prevents changes to the structure and windows of a workbook, workbook-level password security helps protect the entire file against unwanted changes..

  1. Open the document that you want to help protect.

  2. On the Review tab, under Protection, click Passwords.

  3. In the Password to modify box, type a password, and then click OK.

  4. In the Confirm Password dialog box, type the password again, and then click OK.

  5. Click Save  Save button .

    Tip: To remove a password, select all contents in the Password to modify box, and then press DELETE .

See also

Protect a sheet

Protect a workbook

Restrict permission to content in a file

Kas vajate veel abi?

Täiendage Office'i kasutamise oskusi
Tutvuge koolitusmaterjalidega
Kasutage uusi funktsioone enne teisi
Liituge Office Insideri programmiga

Kas sellest teabest oli abi?

Täname tagasiside eest!

Täname tagasiside eest! Tundub, et võiksime teid kokku viia ühega meie Office'i tugiagentidest, kes aitab teil probleemi lahendada.

×