Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnAction
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OnAction
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. -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - onAction arguments | Excel Worksheet Functions | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
OnAction of Menu Bar with variable parameters | Excel Discussion (Misc queries) | |||
Timing problem with OnAction! | Charts and Charting in Excel | |||
.ONACTION macro call fails | Excel Discussion (Misc queries) |