Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macros available to other excel files
I have a macro I copied from a website to one particular file. Is there a way
to make it available to other excel files without having to copy it to every file I want it in? Seems I did this before but can't recall how. I don't really care if its available to every excel file I have since I am the only person using this computer and I trust this macro. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macros available to other excel files
Store the macro in your Personal.xls workbook to have it available for all open
workbooks. If you don't have a Personal.xls yet, with your workbook open, go to ToolsMacroRecord a new MacroStore Macro in;Personal Macro Workbook. Record yourself copying and pasting something then Stop Recording. Alt + F11 to open the VBEditor. You will see the two workbooks. Yours and Personal.xls Copy the macros/functions from your workbook into the module1 in Personal.xls. Note: any hard-coded sheets or books should be changed to ActiveSheet or ActiveWorkbook Delete the bogus copy/paste macro if you choose. Personal.xls can be hidden and saved so's it always opens in the background with macros available. Clear the maros/functions from the original workbook if the above works OK. An alternative to Personal.xls is to open a new workbook, copy the macro(s) to a module in that workbook. Save As an Add-in which you load through ToolsAdd-ins. Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 06:29:01 -0700, Fred Zack wrote: I have a macro I copied from a website to one particular file. Is there a way to make it available to other excel files without having to copy it to every file I want it in? Seems I did this before but can't recall how. I don't really care if its available to every excel file I have since I am the only person using this computer and I trust this macro. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macros available to other excel files
Every macro in any open workbook is available to any and all other open
workbooks. It is customary, to do what you want to do, to place that macro in your Personal.xls workbook. That workbook is opened automatically whenever Excel is opened, and is usually a hidden workbook. HTH Otto "Fred Zack" wrote in message ... I have a macro I copied from a website to one particular file. Is there a way to make it available to other excel files without having to copy it to every file I want it in? Seems I did this before but can't recall how. I don't really care if its available to every excel file I have since I am the only person using this computer and I trust this macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros making files slower and slower | Excel Discussion (Misc queries) | |||
Can't Open Excel Files with Macros | Excel Discussion (Misc queries) | |||
Making Macros Available in All Workbooks | Excel Worksheet Functions | |||
How do I stop Excel from making copies of files? | Excel Discussion (Misc queries) | |||
Making files with excel | Excel Worksheet Functions |