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.

On Aug 5, 9:19*am, Kirby wrote:
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.

There is no good solution to this problem. Best bet would be to hire a
consultant to figure this one out. Good luck.