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