OnAction

[Richard Yang]

if i set the onaction property for a commandbarbutton with
onaction = "module.xla!func1"
what is the search path it would use to find module.xla
would it make a difference if this statement was run
inside of module.xla

Thanks,
Richard

 

[Mike]

The command bar button stores the whole path to the file
even though it doesn't show the path if the file is open.
If you close the file, and click the button, the file is
loaded then the function executed. I've never set
OnAction without the file open, but you might be able to
do it using:
OnAction = "C:\PathToFile\Modula.xls!Func1"

Most people keep their routines in their Personal.xls file
though, because it is always loaded automatically when
Excel starts.