Add macro to Excel-file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! In a module I have several user defined function that I use for alot of
things. Therefor I would like to have have them in all my Excel-files as
default. Is it possible to add a macro to an Excel-file? Now I have to paste
the code into theh new file or copy a module using the mouse. Please help!
Thanks alot!
 
Consider placing your macros in Personal.xls, they will be available for all
of your workbooks!

Regards,
Stefi


„Arne Hegefors†ezt írta:
 
Arne

Consider placing the module in a new workbook then saving the workbook as an
Add-in to be loaded through Tools>Add-ins.

Advantage with this method is two-fold.

1. If others are to use the functions, you don't have to overwrite their
Personal.xls, just send them the add-in.

2. You don't have to add the filename to your functions.

=MyFunction(cellref) with the add-in.

=Personal.xls!MyFunction(cellref) when using Personal.xls


Gord Dibben MS Excel MVP
 
Back
Top