Templates ignore Protection Setting?

  • 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
 
I'm not sure I understand what you're saying, but cell protection is not a
function of file protection. If you're using the password dialog you access
from the "Save As" dialog, that's not going to do it. You need to use the
Tools | Protection | Protect Sheet... or Protect Workbook... functionality.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top