Forum Discussion
Protecting a worksheet and cooying output table to a word document
Hi, I have designed a table for use to clarify how how debt has occurred. I have 2 tables on the spreadsheet. The first is the input table, the second the output table. I have managed to ...
When you click Protect Sheet on the Review tab of the ribbon, Excel displays a dialog:
Make sure that you leave the check box "Select locked cells" ticked.
Users will then be able to select and copy ranges, without being able to edit them.
No. That doesentt work.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
- Will do