View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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