modify password protected xls document

**briana banks** · 12-01-2008, 02:43 AM

Hi All

I want to lock my template in a way that the macro i run will be able
add or delete rows to the template but no one will be able to modify the first 3 rows
and other things related to the template such as header and footer.
in addition i dont want to save the macro within the xls document.
when i use SaveAs method it saves the new file with the macro
editable.

Thanx

**royUK** · 12-01-2008, 04:56 AM

Place the code in an Exel addin, *.xla then itwon't actually be in the template.

**briana banks** · 12-02-2008, 03:16 AM

Hi

what you mean by putting the code in xla document?
do you mean rename my template from xls to xla?
if i do so excel appears visible.and the code is transferred to the destination
file.