| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
I don't know what's going wrong for you but I just created a template having
a worksheet with protection on and then I created a new workbook from it. It was protected. This should work; protection does not disappear, nor do cells that are locked become unlocked. -- Jim "Kikkoman" wrote in message ... |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? | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
| password protect .csv files | Excel Discussion (Misc queries) | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
Linear Mode
