| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a "Defualt" macro that is available in any and/all workbo
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a "Defualt" macro that is available in any and/all workbo
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a "Defualt" macro that is available in any and/all wo
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a "Defualt" macro that is available in any and/all wo
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a "Defualt" macro that is available in any and/all wo
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" 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Sending macro based e-mail with built-in "Heading" and "Text" | Excel Programming | |||
| Creating an "update" button and using a macro to copy data from multiple sheets | Excel Programming | |||
Linear Mode
