Hi Lee,

Will you be making the same change to every workbook?

If so, code exists to open everywork in a folder, call another macro (which
will make the changes you want) save, close and move onto the next one.

Thanks,

Simon

Lee wrote:
I have a number of template worksheets that people enter data into in
contained in several workbooks. What is the best way to make changes to
these templates for necessary updates all at once like adding a cell w/ data
validation or a row of information etc.. I have used the Group function to
try and do some of this but it does not work for everything and is somewhat
tedious.

Do folks typically develop Macros to do this?? If so are there any examples
out there of some typical Macros to address this.