Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect template worksheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
protect template | New Users to Excel | |||
Protect formulae in template | Excel Discussion (Misc queries) | |||
How do I copy protect an Excel template | Excel Discussion (Misc queries) | |||
Help with creating template for users, need to protect cells, but... | Excel Programming |