How to create a global Excel user defined function.

Posted on 2007-08-07
Last Modified: 2012-08-13
How to create a user defined function in Microsoft Excel that can be accessed through all access spreadsheets?

To do this locally I open the VB editor and write what I would like. But I would like to access the same function from any worksheet I do without having to re-write it.
Question by:Sean Meyer
    1 Comment
    LVL 85

    Accepted Solution

    You can store the function in an add-in or in your personal macro workbook (Personal.xls). If you store it in Personal.xls, when you use it in a worksheet, you need to prefis the function name with teh name fo the workbook it is stored in, so you would use:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    Automate double vlookup using VBA 11 58
    Excel file corrupted. 13 28
    Storing values to an array 8 42
    How to debug this code 7 28
    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now