| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
I am new at running macro's and have written one and ran it in the same excel
instance but when I close excel and open a new workbook and try to run the macro it is not there to run. -- Mary C |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help
Macros a generally Worbook secific unless it is in your PERSONAL.xls
"Mary C" wrote: I am new at running macro's and have written one and ran it in the same excel instance but when I close excel and open a new workbook and try to run the macro it is not there to run. -- Mary C |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help
I did save the macro in the personal.xls file but still when I go to rerun it
there is not a macro there. Thanks for your response. -- Mary C "Office_Novice" wrote: Macros a generally Worbook secific unless it is in your PERSONAL.xls "Mary C" wrote: I am new at running macro's and have written one and ran it in the same excel instance but when I close excel and open a new workbook and try to run the macro it is not there to run. -- Mary C |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help
The Personal.xls also has to be saved to the XLStart folder if you want it
available for each instance of Excel. See Ron's site. http://www.rondebruin.nl/personal.htm "Mary C" wrote: I did save the macro in the personal.xls file but still when I go to rerun it there is not a macro there. Thanks for your response. -- Mary C "Office_Novice" wrote: Macros a generally Worbook secific unless it is in your PERSONAL.xls "Mary C" wrote: I am new at running macro's and have written one and ran it in the same excel instance but when I close excel and open a new workbook and try to run the macro it is not there to run. -- Mary C |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help
thanks for your help.
-- Mary C "JLGWhiz" wrote: The Personal.xls also has to be saved to the XLStart folder if you want it available for each instance of Excel. See Ron's site. http://www.rondebruin.nl/personal.htm "Mary C" wrote: I did save the macro in the personal.xls file but still when I go to rerun it there is not a macro there. Thanks for your response. -- Mary C "Office_Novice" wrote: Macros a generally Worbook secific unless it is in your PERSONAL.xls "Mary C" wrote: I am new at running macro's and have written one and ran it in the same excel instance but when I close excel and open a new workbook and try to run the macro it is not there to run. -- Mary C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
![Mary C[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
