Excel 2010 - Copying sheet with protection manually, protection stays... not with VBA

[AdamParker]

Hello,
When I manually copy a sheet using VBA the protection on it stays, which is exactly what I want.
However, when I do this using VBA, the protection disappears.

I need to have the protection remain, it's initially applied in the ThisWorkbook module as it is special in order to allow a user to expand/collapse groups.

I'd like to have this protection copied to all of my sheets.

The sheets are created based off of a template, this template is the one with the protection and because they don't exist before, I can't just add them into the code for when the workbook opens.

Any ideas?

Here are the code snippets:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Any help would be appreciated.
Thanks

[AdamParker]

Bump no response

[jaslake]

Hi Adam Parker
I have no way to test this but I'd think you could do something like this

Please Login or Register  to view this content.

[AdamParker]

Thanks for your help - this worked great!

[jaslake]

Hi AdamParker

You're welcome...glad I could help. Thanks for the "style points".