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

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 wrote:

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

Hi Dave,

Thanks, this is a good suggestion.

John

"Dave Peterson" wrote:

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 wrote:

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