Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
I have created numerous macros in an Excel workbook. I have created
the following macro to run all macros at once. Sub A_Run_CF_Sensitivities() ' ' A_Run_CF_Sensitivities Macro Application.Run "'Model Kirby version macro.xlsm'! CF_Copy_Original_Economics" Application.Run "'Model Kirby version macro.xlsm'!CF_PricePerX" Application.Run "'Model Kirby version macro.xlsm'!CF_PricePerX" End Sub This original workbook will be modified and saved as other workbooks over time. I assumed that all macros would copy and work independent of the original workbook. This is no the case. I am having a problem because the macro above specifies only the macros in the original workbook. How can I write this command so that it will copy and run independent as I copy the workbook as other workbooks? Thank you in advance for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |