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 protect the output table. However, I need to be able to copythe output table to a word document. But, once I protect the sheet, I cannot copy the output table.
As this output table is going to be used by hundreds of people, I need to ensure the integrity of the output table remains fully protected.
Can anyone advise me how I can keep the output table protected, yet, be able to copy it to a word document.
Thanks in advance.
Declan moloney
5 Replies
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.
- Many thanks. Ill try tgat in the morning.
