changes to the same worksheet within multiple files

G

Guest

I have a master workbook that has 9 different workseheets
in it. The master has been saved to over 200 files.
Certain things need to be changed within the 200 files on
certain worksheets. Is there any way to make changes to
ALL 200 sheets at one time, aside from a macro, or
changing each affected worksheet individually?
 
D

Don Guillett

AFAIK you would have to use a looping macro to open each workbook>make the
changes>save & close.
 
G

Guest

Ron,

You are the BEST!!! Quick question, once I set up the
macro and perform the needed changes, if I "deep six" the
macro, will the changes hold? I don't want users to be
involved with the macro.
 
R

Ron de Bruin

Hi

The users don't see the macro
The macro is in the master workbook

You copy a range or sheet from the master workbook to all workbooks
and save each workbook in the loop with this line

mybook.Close True
 
Top