User Defined Functions in the Personal Macro Workbook

[Nate]

When using a UDF stored in the Personal Macro Workbook, is there a way
to eliminate the need to type the name of the workbook
(PERSONAL.XLS!...) before the function name? Or, if not, is there a
way to change the name of the Workbook to something much shorter, like
one letter?

 

[Bob Phillips]

Just rename it in the XLStart directory.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Peo Sjoblom]

Another thing is to put the UDF in a workbook and save it as an add-in
(*.xla) then select it under tools>add-ins

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com