I am working on budget files for our new fiscal year. I need to update all of
my macros from referencing budget 08-09 to referencing budget 09-10. The
problem is, I have over 100 worksheets included within the macro to change to
the new budget year, but I don't want to have to go into each macro and
manually change 100 worksheet names. How can I update all the macros at the
same time or can I?
Thanks.