• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 867
  • Last Modified:

How to create a global Excel user defined function.

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.
0
Sean Meyer
Asked:
Sean Meyer
1 Solution
 
Rory ArchibaldCommented:
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:
=Personal.xls!functionname()
Regards,
Rory
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now