Sub or Function not defined

D

dCromley

Long time XL97 user, now XL2003.
I've used excel macros for years and don't remember having to do this:

I have macros in my Personal.xls that I use in all my workbooks.
If I get "Sub or Function not defined" error, I have to reference
Personal.xls using Tools/References and pick it out.

But Personal.xls is named "VBAProject(PERSONAL.XLS)" and my new
workbook is named "VBAProject(Book1.xls)", so I get
"Name conflicts with existing module, project, or object library".
So I have to make my Personal.xls in a different project.
I do this in the project explorer by right-clicking
"VBAProject(PERSONAL.XLS)" and hitting properties and changing
the project name. Then I can add it as a reference.

See http://support.microsoft.com/kb/156882

Like I say, I don't remember having to go thru all this, and I found
few hits on searching this, so that's the reason for this post.

Maybe I missed something, because why can't I just use the
Personal.xls in the same project without even adding a reference?
 

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

Sub or Function not defined 3
Project Code Communication 2
Custom UDF 2
How do I access a sub in a New Class 5
Calling a Sub in Personal.xls 2
The best way to build your own VBA library 2
Call Macro from PERSONAL.XLS 4
Sub, Private Sub, Public Sub 4

Top