I have created a template to use at my office that I need to share with other
employees to use. The template is locked with only necessary cells opened
for data entry. The issue I'm having is these templates need to be locked
completely once the data has been entered so they cannot be altered. I can't
lock the worksheet completely without first unlocking the template. Is there
was way to share a locked template that gives others the ability to lock the
data they've entered but not have access to altering any other aspects of the
original template?