Calling macro's from another workbook

[taz23340]

Hi Everyone,

I have been combining multiple macro's into one large Macro and after research, it seems that only the call function works without any hitches.

Is there a way to use the call feature in one workbook while the macro's themselves, 5 or 6 of them, are in another workbook that is closed?

All users would have access to both workbooks.

The reason I am trying this is because I do not want all the other users to have to choose between multiple macro's and some of my colleagues like to use a radio button to link to the workbook. so it needs to have one file in it...

thanks for your help
kevin

 

[taz23340]

That worked great....thanks so much...and much faster...im working on shrinking the recorded code now, but thats another topic lol....its just hard to figure out where to start to write when your so used to recording your mouse clicks....

thanks again
very much appreciated.
kevin