Store UDF and use it on other machines not in network
 

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

Store UDF and use it on other machines not in network
 

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" wrote in message
...
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

Store UDF and use it on other machines not in network
 

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" wrote in message
...
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