![]() Make sure that you choose a password that is easy to remember, because if you lose the password, you won't have access to the protected. Open the excel spreadsheet you want to lock. Split panes to lock rows or columns in separate worksheet areas. Click the green 'file' tab on the ribbon. ![]() When you create a worksheet, sometimes you need to use some formulas, and you don’t want other users to change, edit or delete the formulas. This can be confusing because as you know, you can change them. Then select the cells you allow users to edit in future. ![]() Here also is a simple code for you to solve this job, please do as follows: At that time the workbook and/or specific > worksheets lock, allowing read only. Protect and Unprotect Excel Worksheet with or without Verify all cells are locked.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |