Store UDF and use it on other machines not in network

[Abhijeet]

Hi,
I created a module/ macro to give me a desired graph. I had stored the code
for the macro in Personal.xls under a function called Graph, which was called
with a key board shortcut "Ctrl+g". I want that our consultants who prepare
data sheets for us be able to use this graph function to create the graph we
want by using the same shortcut. Is it possible to create some executable
code so that when the consultants get my email and open that exe file, it is
run and copies the macro function into their excel program.
Or if there is any other way I can give the consultants the Graph tool.
Thanks
--Abhijeet

[Bob Phillips]

Put the code in an add-in and give them that.

Some starters

http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

http://support.microsoft.com/default.aspx?kbid=156942
XL97: How to Create an Add-in File in Microsoft Excel 97


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Abhijeet" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I created a module/ macro to give me a desired graph. I had stored the
code
> for the macro in Personal.xls under a function called Graph, which was
called
> with a key board shortcut "Ctrl+g". I want that our consultants who
prepare
> data sheets for us be able to use this graph function to create the graph
we
> want by using the same shortcut. Is it possible to create some executable
> code so that when the consultants get my email and open that exe file, it
is
> run and copies the macro function into their excel program.
> Or if there is any other way I can give the consultants the Graph tool.
> Thanks
> --Abhijeet

[Abhijeet]

Thanx Bob

"Bob Phillips" wrote:

> Put the code in an add-in and give them that.
>
> Some starters
>
> http://support.microsoft.com/default.aspx?kbid=211563
> How to create an add-in file in Excel 2000
>
> http://support.microsoft.com/default.aspx?kbid=156942
> XL97: How to Create an Add-in File in Microsoft Excel 97
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Abhijeet" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I created a module/ macro to give me a desired graph. I had stored the
> code
> > for the macro in Personal.xls under a function called Graph, which was
> called
> > with a key board shortcut "Ctrl+g". I want that our consultants who
> prepare
> > data sheets for us be able to use this graph function to create the graph
> we
> > want by using the same shortcut. Is it possible to create some executable
> > code so that when the consultants get my email and open that exe file, it
> is
> > run and copies the macro function into their excel program.
> > Or if there is any other way I can give the consultants the Graph tool.
> > Thanks
> > --Abhijeet
>
>
>