Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: Excel function or sub routines available to all excel present and furture

    Excel 2k
    Win 2k and XP

    I want to write either a module or excel sheet sub routines or functions and make those available to all the excel application present past and future just as objects are available in the excel vb library. How do I do that???

    alex

  2. #2
    Join Date
    Dec 2004
    Posts
    37
    Hi Alex,

    You can put all the routines you want in a single Excel file and save it as an add-in, then install the add-in.

    This will make all the functions and routines in the add-in available to your current worksheet. However only on the machine that contains the add-in. If you use the file on another machine any functions used will be unavailable.

    Mike

Posting Permissions

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