Sub or Function not defined

[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 you get "Sub or Function not defined" error, you have to reference
your Personal.xls using Tools/References and pick it out.

But Personal.xls is named "VBAProject(PERSONAL.XLS)" and your new
workbook is named "VBAProject(Book1.xls)", so you get
"Name conflicts with existing module, project, or object library"
So you have to make your Personal.xls in a different project.
You do this in the project explorer by right-clicking
"VBAProject(PERSONAL.XLS)" and hitting properties and changing
the project name. Then you 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?

 

[Peter Jamieson]

I expect there are plenty of people in this /Word/ group who know the
answer, but suspect you are more likely to get an informed answer in an
/Excel/ group

Peter Jamieson

http://tips.pjmsn.me.uk

 

[Stefan Blom]

You may want to ask the question in an Excel newsgroup instead. This one is
for Word.

 

[dCromley]

Sorry, wrong newsgroup