Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change function to macro
I have a simple function which compares a datafield on 2 separate worksheets
in same book. How do I take the code for the funct. and convert it to a macro so I can call it as needed for all of my work? thx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change function to macro
You don't convert it to a macro. The best way I know to be able to access
your function regardless of what workbook you are using is to create an add-in and then attach the add-in to Excel. One way to do this is: Open a blank workbook Add your function code to a module in this workbook. Save the workbook as an addin: Select "Save as" with a meaningful file name and then select "Microsoft Excel Add-n(*.xla) from the Save as Type drop down box. Then Select Tools, Add-Ins and browse to the file you just created. Now you can use the function by typing it in a cell or by selecting in under User Defined Functions in the Function Wizard. "Brian" wrote: I have a simple function which compares a datafield on 2 separate worksheets in same book. How do I take the code for the funct. and convert it to a macro so I can call it as needed for all of my work? thx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change function to macro
Why can't you call a function for all of your work?
-- HTH RP (remove nothere from the email address if mailing direct) "Brian" wrote in message ... I have a simple function which compares a datafield on 2 separate worksheets in same book. How do I take the code for the funct. and convert it to a macro so I can call it as needed for all of my work? thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Insert row at change macro - how to change it. | Excel Discussion (Misc queries) | |||
macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming |