To prevent other users from opening a workbook by encrypting a password: Preventing other users from opening a workbook Choose the desired option from the menu.īelow are the options to protect a workbook: Click Protect Workbook or Encrypt with Password and then Protect Workbook.Open the Excel workbook you want to protect with a password.You can use password protection to add security and prevent other users from opening a workbook, changing a worksheet or worksheets or altering workbook structure. The easiest option is to use the File tab in the Ribbon. If you want to prevent users from accessing or changing a workbook, password protection can be added to your Excel file in a number of ways. You can lock and protect an Excel workbook by adding a password using your security options. Lock and Protect Your Excel Worksheets and Workbooksīy Avantix Learning Team | Updated May 31, 2021Īpplies to: Microsoft Excel 2010, 2013, 2016, 2019 and 365 (Windows)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |