Protecting a worksheet and cooying output table to a word document

New Contributor

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

@DECLANYOGA 

When you click Protect Sheet on the Review tab of the ribbon, Excel displays a dialog:

S1666.png

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.

Many thanks. Ill try tgat in the morning.
No. That doesentt work.

@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.