Asterix
05-15-2008, 02:13 AM
Hi all, is there anyway that I could open a spreadsheet, that automatically runs a macro (via "autorun" obviously) where the macro (or a called subroutine) is held in a separate, closed, repository, WITHOUT having to open that repository.
Am asking because I have several replicated spreadsheets that belong to individuals in my team and I have the same autorun macro in each. Problem is, when I need to fix or enhance the autorun macro, I'm doing it 10 times.
I could store that macro centrally and have the individual sheets refer to it, but I don't necessarily want whatever holds that macro to be opened when it runs.
Although I think I'm asking the impossible (as you have to open a macro container to run a macro), am I wrong/ can this be done?
Any other suggestions gladly considered.
Thankyou
Am asking because I have several replicated spreadsheets that belong to individuals in my team and I have the same autorun macro in each. Problem is, when I need to fix or enhance the autorun macro, I'm doing it 10 times.
I could store that macro centrally and have the individual sheets refer to it, but I don't necessarily want whatever holds that macro to be opened when it runs.
Although I think I'm asking the impossible (as you have to open a macro container to run a macro), am I wrong/ can this be done?
Any other suggestions gladly considered.
Thankyou