Centralized Macro

[Guest]

I have created a macro to automate the production of test specifications in
excel.
The problem is that it has become so large that that a blank document (no
user tests) is in excess of 600Kb already and its not even finished yet.

Some of our department have problems opening large files so what I would
like to do is find some way to be able to run the macros needed without
having them embedded in the actual sheet. Hence each working document is much
smaller in size but still has the exact same functionality.

Is this possible? If so does any one know how to do this?

 

[Michael Malinsky]

Try this thread:

http://groups-beta.google.com/group...+macro+from+another+workbook#ddc45630063c2e33

 

[Guest]

Thanks Michael,

From looking at other threads I'd found something like you mention, but the
problem is when I try to run it I get
"Run Time Error 1004 Application defined or object defined error"

How do I fix this?

 

[Guest]

Michael,

Thanks for your help I have now figured it out, an its made a big difference
- a blank document is now 2/3 smaller than my old file with the macro embedded