![]() ![]() Type in the correct password and click OK. If your workbook structure is protected, the Unprotect Workbook dialog box will pop up. Click the File menu in the upper-left corner of the Excel window, and then select Info.Ĭlick the Protect Workbook button and then select the Protect Workbook Structure option from the drop-down list. ![]() If you can remember the workbook structure password, you can easily remove the protection in Excel. Method 1: Unprotect Workbook Structure with PasswordĮxcel allows users to protect the structure (the arrangement of sheets) of all sheets in a workbook. ![]() Here are 2 ways to unprotect workbook structure in Excel 2016 / 2013. Can't insert a new worksheet or delete an existing sheet? The option to add new sheet is greyed out? If the workbook structure is protected with a password, you're unable to add, delete, move, copy, rename, hide or unhide any sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |