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
- Many thanks. Ill try tgat in the morning.
