Template changes to existing workbooks
hi,
just an idea:
you can record a macro and save it to your personal macro file (you
will be asked when recording) and assign a shortcut like ctrl+a. then
you make all the changes to one file and stop recording when your are
finished. then you could open all the files one after each other and
press ctrl+a, save and close the file and open the next one.
when you change your template this cannot effect the files that have
been created using the template.
arno
|