Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: add-ins

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Sheffield, UK
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have written some custom functions for excel in visual basic. They are currently stored in a module in my PERSONAL.XLS project. However there are a lot of people where I work who would like to use them. Is there any way to save the module as an add-in (on the network), so people can just use the Add-Ins on the Tools menu to install them?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, just save your workbook as an add-in (from the save as type drop-down) and inform everyone of it's location. Then all they need to do is select Tools- Add-Ins and Browse to where your file is located and install it.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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