Protecting a worksheet and cooying output table to a word document

[DECLANYOGA]

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

[#2]

@DECLANYOGA 

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.

[#3]

Many thanks. Ill try tgat in the morning.

[#4]

No. That doesentt work.

[#5]

@DECLANYOGA 

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.

[#6]

Will do