Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centralized Macro
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Centralized data | Excel Discussion (Misc queries) | |||
Multiple worksheets, Centralized Formula Repository | Excel Discussion (Misc queries) | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |