kualjo
03-27-2007, 11:13 AM
I created a function in VBA called "FWDMS" that I use in worksheet formulas. When I use it, however, I can't just enter "=FWDMS..." and it's required fields. I have to choose it from the User Defined list under Function category, and when it is entered into the worksheet, it appears as "=PERSONAL.XLS!fwdms.fwdms..." Is it this way because I have it under the Personal Macro Workbook? I use the function for numerous files and don't need to -- or want to -- store it in each individual file. How can I make this function work like a standard Excel-defined function?
Thank you in advance for your assistance.
Thank you in advance for your assistance.