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. |
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) |