A
Angie M.
Hi,
I'm using Excel 2003. I have a workbook file. I have several macros that I
created to work with this particular spreadsheet, they are stored in Module1
inside of this spreadsheet. They work great. I have since used this
spreadsheet to create 4 additional spreadsheets for different regions. So
now I have 5 workbooks containing data for 5 different regions, and they all
have their own copy of my macros. All of a sudden, when I try to use one of
the macros, it's looking for another one of the workbook files. When I open
the one it's looking for, I get a bogus error telling me it can't find the
macros.
How can I save this set of macros to Excel instead of saving to individual
workbooks? I would gladly keep them saved in each workbook but for some
reason they aren't working now. Please help. Thanks!!
I'm using Excel 2003. I have a workbook file. I have several macros that I
created to work with this particular spreadsheet, they are stored in Module1
inside of this spreadsheet. They work great. I have since used this
spreadsheet to create 4 additional spreadsheets for different regions. So
now I have 5 workbooks containing data for 5 different regions, and they all
have their own copy of my macros. All of a sudden, when I try to use one of
the macros, it's looking for another one of the workbook files. When I open
the one it's looking for, I get a bogus error telling me it can't find the
macros.
How can I save this set of macros to Excel instead of saving to individual
workbooks? I would gladly keep them saved in each workbook but for some
reason they aren't working now. Please help. Thanks!!