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?