pTemplate.xlsm

Hello there,

I've been happliy learning a lot about VBA and am at the final stages of my project!!! HOOORAY!
There is just this one last (i think) code that I need for everything to work perfectly. I hope you can help.

The Problem Explained
- I have a data entry sheet containing various formula and control buttons so I need to protect this sheet for obvious reasons.

- But I also need to paste the values into a template that I've created (the template is the same format with different macros and control buttons).
Then, I need to save the template (now containing values) as a name corresponding to B1.

I don't know how to:
* copy values from all the unlocked cells
* paste these values into pTemplate.xlsm (which is also protected)

The path for pTemplate.xlsm is [C:\Property Sheets\1. Templates\pTemplate.xlsm]
The path for data entry form is [C:\Property Sheets\Balance Book.xlsm


If i can give you any more info please ask.