Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls Macro Function for Everyone...
Hey Group!!!
How can I expose a function that I can use after in wherever I want. I tried the following way, but I couldn't In Personal.xls in a new Module: Public Function MyFunction() as string ....Lines End Function when I open new.xls and I write: CellA1= MyFunction(Some Args) I am tryieng to use it like Sum(), for example... It returns to me: N/A So... it is Impposible???? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls Macro Function for Everyone...
=personal.xls!myfunction(somearguments)
=== If you save the personal file as an Addin, you can refer the functions just like they're built in. But you would have to provide some way to get to the macros. Jairo Marin wrote: Hey Group!!! How can I expose a function that I can use after in wherever I want. I tried the following way, but I couldn't In Personal.xls in a new Module: Public Function MyFunction() as string ...Lines End Function when I open new.xls and I write: CellA1= MyFunction(Some Args) I am tryieng to use it like Sum(), for example... It returns to me: N/A So... it is Impposible???? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro runs in source , but not when in Personal Macro Workbook | Excel Programming | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
Custom Function on Personal.xls | Excel Programming | |||
personal.htm & personal.xls in Macro | Excel Programming |