Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing auto-correction in two different machines | Excel Discussion (Misc queries) | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
Need exercise log template (weight machines and such) | Excel Discussion (Misc queries) | |||
Need exercise log template (weight machines and such) | Excel Discussion (Misc queries) |