+ Reply to Thread
Results 1 to 3 of 3

Getting Computer To Remember Codes

  1. #1
    Registered User
    Join Date
    05-28-2019
    Location
    Edinburgh
    MS-Off Ver
    2013
    Posts
    92

    Getting Computer To Remember Codes

    Hi Guys,
    Spreadsheet has lots of pre installed codes that it uses. ie sum, roundup, etc. Is it possible to add in my own codes so that when i open a new work book they are already available?

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Getting Computer To Remember Codes

    Good afternoon jpe1

    Yes it is possible.

    First you will have to write them using VBA (user defined functions), then install your file as an add-in.
    If you do this, then users to whom you send your file will also need your add-in installed to use your file.

    The alternative is to use only the UDF's you need in just the files you need them in - then they will "travel" with the file.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    05-28-2019
    Location
    Edinburgh
    MS-Off Ver
    2013
    Posts
    92

    Re: Getting Computer To Remember Codes

    Sorry for the slow reply. Thank you for helping me.

+ 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. Identical VBA Code works on computer A, throws error on computer B???
    By PWM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2018, 08:15 AM
  2. Replies: 3
    Last Post: 05-18-2018, 08:20 AM
  3. Other Computer waits until the first computer open the file close it.
    By atzdgreat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2017, 05:42 AM
  4. Replies: 2
    Last Post: 10-03-2016, 09:31 AM
  5. Replies: 6
    Last Post: 06-28-2013, 08:44 PM
  6. Replies: 0
    Last Post: 02-08-2010, 03:17 PM
  7. Auto Filter on my home computer differs from my work computer.
    By Sbova0226 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-08-2009, 03:04 PM

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