?
Solved

Personal.xlsb - References in VBA for Excel 2010

Posted on 2013-06-10
3
Medium Priority
?
1,788 Views
Last Modified: 2013-06-29
Hello,
I want to use my functions in all my Excel workbooks, but I don't want to have to type PERONAL.XLSB! in front of the function name every time.
I thought that i hcould permanently add my personal.xlsb vba project as a reference (In Tools -> References) and that my functions would become available just using their vba name (se attached).
Am I wrong about this ? ie: Do I need to create an add-in ?
Any help would be appreciated  - in the attached screen shots I have an example of my personal .xlsb (I have changed the project name to be CS_Project - this is the library of functions I would like to add to the references dialog box, also attached).
I hope this makes sense - I'm looking forward to any replies as this is driving me a bit mad now !!

Best regards,

Craig
Project name exampleTools -> References
0
Comment
Question by:slobber72
3 Comments
 
LVL 39

Assisted Solution

by:nutsch
nutsch earned 750 total points
ID: 39236295
For functions to work without the workbook name, you'll have to put them in an add-in that's not your personal.xlsb.

Little setup time, but once setup not much maintenance issue.

This tutorial has got it all described: http://fontstuff.com/vba/vbatut03.htm

Thomas
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 750 total points
ID: 39236303
0
 

Author Closing Comment

by:slobber72
ID: 39287629
Sorry for the delay - I was able to find what I needed from these references.

My main issue - I was trying to reference a project to itself.  DOH!

Using the addins will be a good future solution for me though.

Thanks again for the time spent looking at this for me.

Craig
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question