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