Protect template worksheet

  • Thread starter Thread starter DocBrown
  • Start date Start date
D

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
 
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.
 
Back
Top