use function and sub from personal.xla

[avveerkar]

I have some functions and subs written and stored in personal.xls. I can use functions as worksheet functions in my worksheet. Also I have created buttons on the tool bars and these buttons are assigned to the subs in the personsl.xla. This also works fine. But if I want to use the function or any of these macros in my procedure how do I do that? eg. One of the macros is Test(). If I want to call it from my procedure just by having a line "Test" does not work ( undefined function or macro error ). I need to tell the excel that it is in personal.xla. What is the syntax?

Thanks

A V Veerkar

[mlafentres]

Try this

Application.Run "personal.xls!Test"

also, I think Test must be Public rather than Private.

Good luck,

Mark

[avveerkar]

Try this

Application.Run "personal.xls!Test"

also, I think Test must be Public rather than Private.

Good luck,

Mark

Thanks. That works.