Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make my functions public to all workbooks?
1. what does the .xla do for me? Personal.xla?
2. I have 2 modules in my personal.xls w/ functions in them but I dont seem to have access to them from another worksheet. I wrote this function Function CopyFormula(sSumRng As Range) As String Application.Volatile True CopyFormula = sSumRng.Formula End Function so that when I enter this into a cell on a worksheet =copyformula("A1") I get the actual formula and not the result. The only way I can get this to work is by placing this into a module within the current excel workbook that I am working in. I too want to put all of my functions in a single file, personal.xls/xla, so that they are available to any workbook. It sounds like I need to reference the personal workbook and or the function module to make this work. How do I do that? Or How do I use the xla extension to shortcut the solution? Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make my functions public to all workbooks?
Use =Personal!CopyFormula
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "DMB" wrote in message ... 1. what does the .xla do for me? Personal.xla? 2. I have 2 modules in my personal.xls w/ functions in them but I dont seem to have access to them from another worksheet. I wrote this function Function CopyFormula(sSumRng As Range) As String Application.Volatile True CopyFormula = sSumRng.Formula End Function so that when I enter this into a cell on a worksheet =copyformula("A1") I get the actual formula and not the result. The only way I can get this to work is by placing this into a module within the current excel workbook that I am working in. I too want to put all of my functions in a single file, personal.xls/xla, so that they are available to any workbook. It sounds like I need to reference the personal workbook and or the function module to make this work. How do I do that? Or How do I use the xla extension to shortcut the solution? Thanks for the help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make my functions public to all workbooks?
Try using
=Personal.xls!copyformula(A1) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "DMB" wrote in message ... 1. what does the .xla do for me? Personal.xla? 2. I have 2 modules in my personal.xls w/ functions in them but I dont seem to have access to them from another worksheet. I wrote this function Function CopyFormula(sSumRng As Range) As String Application.Volatile True CopyFormula = sSumRng.Formula End Function so that when I enter this into a cell on a worksheet =copyformula("A1") I get the actual formula and not the result. The only way I can get this to work is by placing this into a module within the current excel workbook that I am working in. I too want to put all of my functions in a single file, personal.xls/xla, so that they are available to any workbook. It sounds like I need to reference the personal workbook and or the function module to make this work. How do I do that? Or How do I use the xla extension to shortcut the solution? Thanks for the help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make my functions public to all workbooks?
Someone else mentioned that adding the .xla extension to the personal file, I
think, makes my functions in the personal file public. Do you know anything like this? I am going to try it but I am flying blind. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing source on multiple workbooks | Links and Linking in Excel | |||
# of Functions per cell | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Workbooks... | Excel Discussion (Misc queries) |