6

I wrote the macro in Excel and want to distribute it to the users. Once opened I want the macro to add itself as a toolbar and then to be always visible whenever the Excel is opened. So the macro can be conveniently accessed used from all workbooks.

Deduplicator
  • 44,692
  • 7
  • 66
  • 118
user652061
  • 303
  • 3
  • 4
  • 14

2 Answers2

14

IMHO, the easiest way is to create an add-in with your code and give it to the users.

See this link on ozgrid to learn how to build addins.

JMax
  • 26,109
  • 12
  • 69
  • 88
  • 3
    Prevent linkrot! Post the pertinent details of any outside links here and credit the original author. – James Sep 29 '11 at 13:17
  • 2
    I don't think this is relevant here because I won't copy/paste the whole ozgrid page (which will be far relevant there than here). As far as I can tell and considering the OP's question, there is no *specific relevant* information that would be more interesting here than a link to the page. If I missed anything, please tell me what kind of information I should have copied here so that I can learn. – JMax Sep 29 '11 at 13:29
  • +1, and the links at Ozgrid are very stable - trust me. – Reafidy Sep 29 '11 at 20:04
  • Yeah, there are some sites worth worrying about, but Ozgrid is not one of them :) – Gaijinhunter Sep 30 '11 at 09:06
1

For Sub's tied to toolbars an Addin - as said by JMax - would be my choice. For formulae specific to your business a regular empty Excel file with one or more modules containing Function Xxx(), placed in the Autostart folder would be sufficient.

A server directory which is added to the user's path of Autostart folders is an easy way to auto-distribute formulae.

I am using the latter for instance for IP address calculations

MikeD
  • 8,861
  • 2
  • 28
  • 50