Copy & paste from one sheet to another on a protected sheet???

[melliard5779259]

I have spent ages creating a work diary and have protected the sheets using VBA however on finishing the sheet one important thing that needs to happen is the ability to copy and paste information from the boxes to another worksheet. i.e MONDAY - SUNDAY

[RudiS]

If its just a manual copy/paste scenario from one sheet to another, you may need to consider setting up the destination sheets with locked/unloacked cells so protection can reside on the sheets except in the cells where you need to paste.