Excel Add-Ins

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

Gee...just wonder can we create our own add-ins? That is to say
supposing I have created a simple VBA...and I don't want to load i
manually..I want it to automatically load when Excel starts, can we d
that? If so, how?

Please share your know how..
 
Gilbert,

Yes you can.
1) Take up the macro's in your personal.xls file. In that way your macro's
are always available AND visible in the Run macro dialog
2) A second possibility (more or less the same) is to make an other Excel
file and save it in the Startup directory. All files in that directory are
opened when Excel opens and their macro's (and functions) are available and
visible. (Actually this is what happens with Personal.xls as well by the
way)
3) Create an Excel file (with macro's and/or functions) and Save as ..
xla file. In that case however the macro's are NOT visible in the Run
macro dialog and in the function wizard. You have to create access to
them by buttons or menu choices etc.
(You will ofcourse also have to install the addin).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
In the Save As dialog, choose Add-in from the Format drop-down menu.

You can put your add-in in the XLStart file to load automatically, or
use the Tools/Add-ins menu.
 
gilbert

If you have Personal.xls which is a Personal Macro Workbook, you can store the
macros in there.

Addressing your "add-ins" question, yes, you can File>Save As>File
Type>Add-in(*.xla) which you will find at the bottom of the File Types list.

Store this in your Office\Library folder and checkmark it in Tools>Add-ins.

The add-in route is preferable to the Personal.xls route maily because when
assigning macros to button, menu items etc you do not have to prefix the macro
name with the workbook name.

Just type macroname as opposed to Personal.xls!macroname

Note: macros in Add-ins won't show up in Tools>Macro>Macros list.

Gord Dibben Excel MVP
 
Back
Top