Moving Macros Around

**jasoncw** · 01-28-2007, 09:30 PM

I have been using a spreadsheet for the past few years, and as time has gone by, I have added more and more functionality to the workbook (thanks in part to this great forum!). And of course, with more functionality comes lots more code.

I have several macros written in one module, and to help organize things, I created several modules, and cut and pasted macros out of the original module into the various new modules.

However, after doing this, some of the object or worksheet code that calls these various macros cannot find the ones that I cut and pasted to new modules. Is there a way around this? Or am I stuck having one huge module? Or is this just an Excel 97 thing, and I need to get our slow IT department to upgrade our PCs? LOL

TIA

Jason

**Bryan Hessey** · 01-29-2007, 04:26 AM

Originally Posted by jasoncw

I have been using a spreadsheet for the past few years, and as time has gone by, I have added more and more functionality to the workbook (thanks in part to this great forum!). And of course, with more functionality comes lots more code.

I have several macros written in one module, and to help organize things, I created several modules, and cut and pasted macros out of the original module into the various new modules.

However, after doing this, some of the object or worksheet code that calls these various macros cannot find the ones that I cut and pasted to new modules. Is there a way around this? Or am I stuck having one huge module? Or is this just an Excel 97 thing, and I need to get our slow IT department to upgrade our PCs? LOL

TIA

Jason

Sounds like an excellant opportunity to persuade management that 10 year old software really isn't up to today's expected standard.

hth
---