| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros available in ALL spreadsheets
Hello
I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros available in ALL spreadsheets
Have a look here
http://www.rondebruin.nl/personal.htm Mike "Pascale" wrote: Hello I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros available in ALL spreadsheets
Under your Excel Program files there is a folder named XLStartUp
In that folder you can create a file named personal.xls and in it (that is in the VBE portion of the file ONLY) and whatever Macros (Usually (99%) in a Standard Module) - After entering your Macros there Save Personal.xls (but first Do a Window - Hide command) This way you never see it but it is automatically load every time you open Excel - and Macros THEREIN are available to you through out all your sessions. You will have to Exit Excel after creating the file (If it doesn't already exist) and re-open excel (to grab and open personal.xls) HTH Jim May "Pascale" wrote in message : Hello I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros available in ALL spreadsheets
I don't have a "personal.xls" file on my PC. Most of my macros work globally
in all workbooks (though the macro does not appear on a list when I open that workbook, but the toolbar button operates the macro appropriately), however, a couple of them only work by opening the specific file the macro was created in. Without creating a "personal.xls" file, how can I get those two macros to work globally? Any idea why most of them do work globally without "personal.xls"? I can't even find where those global macros reside. "JMay" wrote: Under your Excel Program files there is a folder named XLStartUp In that folder you can create a file named personal.xls and in it (that is in the VBE portion of the file ONLY) and whatever Macros (Usually (99%) in a Standard Module) - After entering your Macros there Save Personal.xls (but first Do a Window - Hide command) This way you never see it but it is automatically load every time you open Excel - and Macros THEREIN are available to you through out all your sessions. You will have to Exit Excel after creating the file (If it doesn't already exist) and re-open excel (to grab and open personal.xls) HTH Jim May "Pascale" wrote in message : Hello I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros available in ALL spreadsheets
Right click a commandbar, select "Customize..." then right click the macro button and select "Assign
Macro..." and a dialog will come that will show the file name and macro name. It may be in an add-in.... Look under Tools / Add-ins, and see if the file is refrenced there. HTH, Bernie MS Excel MVP "opieandy" wrote in message ... I don't have a "personal.xls" file on my PC. Most of my macros work globally in all workbooks (though the macro does not appear on a list when I open that workbook, but the toolbar button operates the macro appropriately), however, a couple of them only work by opening the specific file the macro was created in. Without creating a "personal.xls" file, how can I get those two macros to work globally? Any idea why most of them do work globally without "personal.xls"? I can't even find where those global macros reside. "JMay" wrote: Under your Excel Program files there is a folder named XLStartUp In that folder you can create a file named personal.xls and in it (that is in the VBE portion of the file ONLY) and whatever Macros (Usually (99%) in a Standard Module) - After entering your Macros there Save Personal.xls (but first Do a Window - Hide command) This way you never see it but it is automatically load every time you open Excel - and Macros THEREIN are available to you through out all your sessions. You will have to Exit Excel after creating the file (If it doesn't already exist) and re-open excel (to grab and open personal.xls) HTH Jim May "Pascale" wrote in message : Hello I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros available in ALL spreadsheets
Bernie,
That was the first thing I tried. No macros are shown in the pop-up box. It is a real mystery where the macros are residing and why they are working without opening the workbook where they reside. Chris "Bernie Deitrick" wrote: Right click a commandbar, select "Customize..." then right click the macro button and select "Assign Macro..." and a dialog will come that will show the file name and macro name. It may be in an add-in.... Look under Tools / Add-ins, and see if the file is refrenced there. HTH, Bernie MS Excel MVP "opieandy" wrote in message ... I don't have a "personal.xls" file on my PC. Most of my macros work globally in all workbooks (though the macro does not appear on a list when I open that workbook, but the toolbar button operates the macro appropriately), however, a couple of them only work by opening the specific file the macro was created in. Without creating a "personal.xls" file, how can I get those two macros to work globally? Any idea why most of them do work globally without "personal.xls"? I can't even find where those global macros reside. "JMay" wrote: Under your Excel Program files there is a folder named XLStartUp In that folder you can create a file named personal.xls and in it (that is in the VBE portion of the file ONLY) and whatever Macros (Usually (99%) in a Standard Module) - After entering your Macros there Save Personal.xls (but first Do a Window - Hide command) This way you never see it but it is automatically load every time you open Excel - and Macros THEREIN are available to you through out all your sessions. You will have to Exit Excel after creating the file (If it doesn't already exist) and re-open excel (to grab and open personal.xls) HTH Jim May "Pascale" wrote in message : Hello I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros available in ALL spreadsheets
Chris,
So, just so I'm clear on what you mean, there is a commandbar button that launches a macro, but the macro is not shown when using the "Customize..."/"Assign macro..." option on that button? Or are you talking about the Tools/Macro... Macros Run macro dialog box? Bernie MS Excel MVP "opieandy" wrote in message ... Bernie, That was the first thing I tried. No macros are shown in the pop-up box. It is a real mystery where the macros are residing and why they are working without opening the workbook where they reside. Chris "Bernie Deitrick" wrote: Right click a commandbar, select "Customize..." then right click the macro button and select "Assign Macro..." and a dialog will come that will show the file name and macro name. It may be in an add-in.... Look under Tools / Add-ins, and see if the file is refrenced there. HTH, Bernie MS Excel MVP "opieandy" wrote in message ... I don't have a "personal.xls" file on my PC. Most of my macros work globally in all workbooks (though the macro does not appear on a list when I open that workbook, but the toolbar button operates the macro appropriately), however, a couple of them only work by opening the specific file the macro was created in. Without creating a "personal.xls" file, how can I get those two macros to work globally? Any idea why most of them do work globally without "personal.xls"? I can't even find where those global macros reside. "JMay" wrote: Under your Excel Program files there is a folder named XLStartUp In that folder you can create a file named personal.xls and in it (that is in the VBE portion of the file ONLY) and whatever Macros (Usually (99%) in a Standard Module) - After entering your Macros there Save Personal.xls (but first Do a Window - Hide command) This way you never see it but it is automatically load every time you open Excel - and Macros THEREIN are available to you through out all your sessions. You will have to Exit Excel after creating the file (If it doesn't already exist) and re-open excel (to grab and open personal.xls) HTH Jim May "Pascale" wrote in message : Hello I would like to have a specific macro to be available to whichever spreadsheet I open. How would I go about this? I work with Excel 2003 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
| HOW DO I TRANSFER EXCEL SPREADSHEETS WITH QUERIES AND MACROS? | Excel Discussion (Misc queries) | |||
Hybrid Mode
