How to make my macros available from any excel file ?

[Rasha]

Hi everybody,

I have written 4 macros to automate my computations in Excel.

How can I make my macros available from ANY Excel file ?
Can I put them in a template file ? Which template file ?

Thanks for help.

Rasha

 

[Chip Pearson]

Rasha,

The best way is to save the workbook containing the macros as an
add-in.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JMay]

OR, you can add them to your Personal.xls Hidden Workbook;
that's the route I like to take...

 

[PCOR]

Once you have done that, how do you activate the macro
Thanks

 

[Chip Pearson]

Since this was posted in worksheet.functions, I assumed he was
talking about user defined functions, which are called directly
from worksheet cells. If these are Sub procedure macros, there
would have to be user-interface elements such as command buttons
or menu items.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

Rasha

You could save them in your Personal Macro Workbook which contains macros
available to all workbooks.

If you don't have a Personal Macro Workbook...........

On menu go to Tools>Macro>Record New Macro.

You will be presented with a dialog box with Macro1 as name of macro. Below
that is "Store macro in". Select Personal Macro Workbook.

Record something simple like copying a cell and pasting. Stop Recording.
Close Excel and you will be asked if you want to save changes to Personal.xls

Click Yes. You now have a Personal.xls in your XLSTART folder which will open
each time you start Excel. When it is open, you can go to Windows>Hide and
make it hidden. Save changes again.

The macros you create or copy to modules in the Personal.xls will be available
for all workbooks.

Assign these macros to Buttons on your Toolbar or to Shortcut keys.

OR you could place the macros in a blank workbook and save as an Excel
Add-in(*.xla) which can be stored in your Office\Library folder and loaded in
Tools>Add-ins.

Gord Dibben XL2002