+ Reply to Thread
Results 1 to 3 of 3

Making macros available on multiple user's computers as an add-in

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    15

    Making macros available on multiple user's computers as an add-in

    I have a vba code that performs a few actions on a file that gets downloaded from a network weekly. The code is basically just to clean up the data and filter out uneccesary stuff. I want this macro to be available as an add-in on my workgroup's computers as well, so that we don't have to work from a template, but that the macro would work in any similar workbook as an add-in. The problem is, though, that we don't have administrative rights on our computers, so we cannot save it as an add-in. I am NOT looking for a way to bypass the admin rights, but I am just looking for the next best solution that could make this available on everyone's computers in this weekly file. It is possible to give the file the same name, e.g. Usage xxxx, with xxxx being the date or something like that.

    I also need a way for them to run this with (maybe) a shortcut key, eg. ctrl + shift + m. Or a button, or something which will enable them to run the code without having to step into the code by pressing Alt F11...I don't really want anyone having access to the code, things might get messed up.

    Any advice would be helpful, please?

  2. #2
    Registered User
    Join Date
    11-14-2010
    Location
    Macau
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: Making macros available on multiple user's computers as an add-in

    As I experienced that addin file is no need to admin's authorized.
    You just in user's excel menu -> Develope -> addin --> browser and add your addin file is ok for every user!

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Making macros available on multiple user's computers as an add-in

    Please assist with the second part of my query as well:

    I also need a way for them to run this with (maybe) a shortcut key, eg. ctrl + shift + m. Or a button, or something which will enable them to run the code without having to step into the code by pressing Alt F11...I don't really want anyone having access to the code, things might get messed up

+ 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. Replies: 1
    Last Post: 07-18-2013, 09:31 AM
  2. run macros on entire network of computers once clicked
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 05:55 PM
  3. [SOLVED] Moving Toolbar and Macros To Other Computers
    By amyxkatexx in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-15-2010, 12:30 PM
  4. Macros on other computers....
    By Sparkybear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2008, 09:47 AM
  5. [SOLVED] How do I transfer macros in excel between two computers?
    By diningdesk in forum Excel General
    Replies: 1
    Last Post: 06-28-2005, 12:05 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