View Single Post
  #1   Report Post  
Kikkoman
 
Posts: n/a
Default Protect .xls that were created from .xlt

I have created a expense template with protection so that user cannot change
the formatting of the .xlt
When user opens the .xlt, a new.xls is created but all the protection are
lost, they could change formulas and formats!!!

How do i prevent this?
Must i use a macro?