Excel Templates

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

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.
 
Elizabeth

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

Andy.
 
Back
Top