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