Forum Discussion
Excel Spreadsheet locking/protecting help
You Sir, are an absolute genius! Thank you so very much for your help. It works! You're a good man. Have a good weekend.
You write "I don't want that person/organization to be able to make any changes to any formulas, or any cells or columns, nor be able to copy any cells / columns.".
But that would also make it impossible to "add/subtract/multiply/divide any of the cells and/or columns"...
- Oh I see. Okay, so that could be fine too. They'll just have to manually create a separate sheet and retype the numbers, in the event that the may want to calculate, I suppose. I'm fine with that, yes. Is the rest of my query possible then still? Thank you for your kind response.
Activate the Review tab of the ribbon.
In the Protect group, click Protect Sheet.
Clear the check boxes 'Select locked cells' and 'Select unlocked cells'.
If you wish, enter a password that will be needed later on to unprotect the worksheet.
Don't forget this password!
Click OK.
If you provided a password, you will have to enter it again as confirmation.
Save the workbook.
You Sir, are an absolute genius! Thank you so very much for your help. It works! You're a good man. Have a good weekend.