[SOLVED] Creating a "Defualt" macro that is available in any and/all workbo

[Darin]

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.

[Kevin McCartney]

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.

[Darin]

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.

[Gord Dibben]

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" <[email protected]>
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.

[Darin]

Gord,

That did the trick. Thanks very much for your help!

Darin

"Gord Dibben" wrote:

> 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" <[email protected]>
> 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.
>
>