Excel Templates

[Elizabeth]

I use excel to do quotes for my customers. I have about
100 or more masters. If I am to busy or not here someone
else will do the quotes for me. My problem is that they
change the format, I need to keep the format. I put all
the quotes into templates, but you can still change the
format. What do I need to do to fix this so the format
can not be changed? Read only does not work because they
can just change it to archive.

 

[Andy B]

Elizabeth

Try locking all of the cells except the ones they input into. Then protect
the sheet.

Andy.