Darin

No, you are not missing a stepm just using the wrong file format if you want
to see the macros when you hit ALT + F8.

Add-in macros do not show up in the Macro dialog box.

To have these show in the macros dialog, store the macros in your Personal.xls
or another *.xls file and place it in your XLSTART folder so's it loads when
Excel opens.

You can have it open "hidden" if you save it hidden.


Gord Dibben Excel MVP

On Wed, 16 Nov 2005 14:21:00 -0800, "Darin"
wrote:

Kevin,

Thank you for your help. I did as you described and the macro is available
within the VB Editor but not via the list of available macros (ALT+F8) within
the worksheets. Am I missing a step?

Darin

"Kevin McCartney" wrote:

Hi Darin,

Sure it is, you need to place you required macro into an Excel workbook
addin, this way when you start Excel your workbook addin is loaded and you
macro is available for all workbooks. You can create an Excel workbook addin
by selecting from the menu bar File | Save As and from the Save As dialogue
box chenage the File As Type to "Microsoft Excel Addin *.xla" it will
automatically save it in your profile Excel Addins folder, so that after
saving the file, from the menu bar select Tools | Addins and from the Addins
pop up box select the browse button. You should see you recently new Addin
File, select it and click on OK. You workbook addin will now be loaded each
time you start Excel, thus your macro is now available.

Hope this helps

ciao
KM

"Darin" wrote:

Pretty simple question, thank you in advance for any help or answers.

Is it possible to create a macro that can be used in any and/or all Excel
workbooks? Essentially a "default" type macro that is available in all new or
existing workbooks.