Thread: Macro Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kirby[_2_] Kirby[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.