No, you need to make the file an add-in if you don't want to use
the workbook name in the formula calls. Creating an add-in
doesn't require changes to the code. Simply do a Save As to save
as an Add-In. Adding a reference won't change anything.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"T Kirtley" wrote in message
...
I have an assortment of general purpose functions in my
Personal.xls vba
module, and I want to use them in worksheets without having to
use a file
reference to the Personal.xls sheet.

For instance, I want a cell containing:
"=CountVisible(RangeName)" to
execute the CountVisible() function in my Personal.xls vba
module. As it is
now, I have to precede the function with a file reference such
as:
"=Personal.xls!CountVisible(RangeName).

Is it possible to do this without creating an .xla for the
functions? If I
do use an add-in won't that complicate making changes to the
code?

I understand that another option is to create a reference to
the vba module
that contains the functions, but where would the reference go?
I don't think
I can add a reference in the Personal.xls module to itself, and
my default
workbooks do not have modules. I feel like I am missing
something.

Thanks in advance to anyone who can put me off in the right
direction.

TK