Newly Created Function not Working

N

nuver

Thank you Frank, I used your suggestion but I still was unable to ge
this to work. This is actually the method I had already used. Would i
be easier to just save this as an addin and have him install the addi
on his machine? Do you think it may work if we do this? Again thank yo
for oyur help
 
K

kkknie

I'll just chime in and give my $0.02 for what it's worth.

To answer your question, a standard module is what you get when yo
insert a module. Standard is as opposed to a Class module (which yo
want no part of at this point I'll reckon).

My only other question would be: is the personal macro workboo
actually being loaded on the user's machine? If you go (in Excel, no
VBA) to the window menubar and click unhide, do you see it? If th
user had never recorded a personal macro to this sheet, it may not hav
been created. You can't create a workbook called Personal.xls and pu
it just anywhere. The specific place on my machine is C:\Documents an
Settings\kkknie\Application Data\Microsoft\Excel\XLSTART. Just
thought.
 
F

Frank Kabel

Hi
if you save it in the personal.xls you have to enter the name of this
file in front of your function e.g.
=personal.xls!your_function_name(...)
 
Top