View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arno
 
Posts: n/a
Default 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