Templates Ignore Protection Settings

  • Thread starter Thread starter Tim K
  • Start date Start date
T

Tim K

Is it just me, or does setting up a workboon as a template
and opening the file up through Excel as a template, cause
Excel to ignore the Protection settings.

I can't seem to get Excel to lock the cells I need locked
when the the file I created is opened as a worksheet.

I open it up as a regular and do a Save As, the Protction
settings are implemented.

When I open up thruogh the template mode, the resulting
file is set to unprotected. Any suggestions?

Tim K
 
Works here.

As an experiment, create a new workbook, protect the worksheet, save it as
an xlt file, close Excel, open the template, try to edit a cell.

Does it work?
 
Back
Top