Macro running Macro Help

[jwindholz2725]

Hey Guys, my issue is when I use a button to run two macros, it is pulling the name of my template to do so. So when I build my excel book with a different name I get an error. I'm not quite sure how to make "WERS_template_cost_R4.xlsm!LinesLockUnlock" to active work book. Now the macro name "LinesLockUnlock" remains the same in every book, it is just the book name that is causing the error. I know I need something like "ActiveBook!LinesLockUnlock" but not quite sure how to incorporate it in. Thanks in advance.


Sub CleanUp()
'
' CleanUp Macro
'


'
Application.Run "WERS_template_costs_R4.xlsm!LinesLockUnlock"
Application.Run "WERS_template_costs_R4.xlsm!ProtectSelectSheets"
End Sub

 

[Andrew Poulsom]

Try:

Application.Run ActiveWorkbook.Name & "!LinesLockUnlock"

 

[jwindholz2725]

That worked perfect. Thanks!!!!!!