Protect template worksheet

[DocBrown]

I have a template workbook and in that workbook I have a worksheet that is a
template sheet. The user will create a working workbook from the template.
Then the user will copy the template sheet to one or more working sheets in
their book. Because of the way I designed the workbook and underlying macros,
the template sheet must always be present.

I can't quite figure out a way to protect this sheet from any alteration but
allow the copies to work normally.

The rub is that the sheet has both locked and unlocked cells and the working
sheets needs to be set with protection on.

What would be the approach to this?

Thanks,
John

 

[Dave Peterson]

Hide the sheet from their view.
Give them a macro that does the dirty work of unhiding, copying (renaming??),
rehiding.

It should stop most users from messing with the original sheet.

 

[DocBrown]

Hi Dave,

Thanks, this is a good suggestion.

John