Aug 14 2022 11:12 AM
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
Aug 14 2022 12:01 PM
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.
Aug 14 2022 12:06 PM
Aug 15 2022 03:23 AM
Aug 15 2022 03:28 AM
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.
Aug 15 2022 04:57 AM