Have you tried recording a macro as you do this manually?

--
Jim
"richzip" wrote in message
...
|I have macro code set up to copy data from a large worksheet into a
template,
| and then save the template with a new name.
|
| I would like to protect the worksheet after copying the data onto it. I
| want the options "select locked cells" and "select unlocked cells" to be
the
| only ones checked.
|
| What macro code can I add to accomplish this?
|
| Thank you