Custom Function & Personal.XLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2000 SR1, Win2kPro

Using a custom function works fine if the module is in my
current workbook, but when I move the function to the
module in my Personal.XLS workbook it does get recognised,
giving me a name error.

My understanding is that Personal.xls modules, etc are
availale to all open workbooks.

Can someone help me to get this working. Thanks.
 
Hi
you have to reference your workbook. so enter in a cell:
=personal.xls!Formula_name()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Personal.xls 6
Why #Name?? 2
Why #NAME? 2
Excel Insert Function form 2
Call Macro from PERSONAL.XLS 4
PERSONAL.xls is locked for editing 2
Create employee attendance db using personal.xls? 3
personal.xls 2

Back
Top