Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Excel 2007 and XP. I wrote some subroutines and functions that I
would like to be able to use in ANY WorkBook. As a simple example function: Function aaa() aaa = "Results of this function" End Function -------------------------------------- In ANY Workbook: sub zzz() dim xxx as string xxx=aaa end sub I've been trying ADDins, XLSTART Folder, Personal.XLSB, setting references, but I seem to be missing something. Setting a reference to the workbook that contains the function (aaa) does work, but then how do you set the reference for ALL WorkBooks? Thanks for any insight, Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
group workbooks/files to make global changes? | New Users to Excel | |||
Make function available to all workbooks? | Excel Programming | |||
Make global Macro/Add-in for all active Workbooks/Sheets | Excel Programming | |||
how to make a function(vb script) global (as in used from every w. | Excel Programming | |||
How to make a function accessible for all workbooks | Excel Programming |