+ Reply to Thread
Results 1 to 2 of 2

Make a function available for all files

  1. #1
    Registered User
    Join Date
    01-05-2022
    Location
    Canada
    MS-Off Ver
    365
    Posts
    1

    Make a function available for all files

    Hi,
    How do I make a VBA function accessible to all the excel files that I use in my system?

    Thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Make a function available for all files

    I store my UDFs in an add-in file (once code is written and debugged, file -> save as -> file type xlam) that is then "installed." Once installed (Excel options -> Addins -> manage addins), then my UDFs are available to all of my spreadsheets.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA: make multiple files from single files
    By vikim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2019, 12:50 AM
  2. How can we make these types of files
    By warriorpoet7176 in forum Excel General
    Replies: 4
    Last Post: 07-17-2014, 08:58 PM
  3. How can we make these types of files
    By warriorpoet7176 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2014, 09:25 PM
  4. make UDF to open files
    By MCCCLXXXV in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2008, 05:54 PM
  5. Make a list from two other lists in different files
    By HouseofRahl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2006, 12:09 AM
  6. [SOLVED] make a list of files in a directory
    By GFN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2005, 02:49 AM
  7. make excel files executable
    By Horatio J. Bilge in forum Excel General
    Replies: 4
    Last Post: 06-28-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1