Rollnation
New Member
- Joined
- Jan 17, 2017
- Messages
- 17
I have a couple subs that call other subs that do not show up in the macro table. I guess because the sub simply contains arguments???
I would like to assign this to a button.
Anyone know how I can get it to show up in the macro table?
******************************
Sub RunSolvers()
If Not ActiveWorkbook Is ThisWorkbook Then Exit Sub
Dim SourceSheet As Worksheet
Set SourceSheet = ActiveSheet
Call SolverLoop
Call CopyPasteBacktestMape
Call SolverLoopFinal
Call SourceSheet.Activate
MsgBox "Solver's are complete. Proceed to model select worksheet to input forecast adjustments."
End Sub
I would like to assign this to a button.
Anyone know how I can get it to show up in the macro table?
******************************
Sub RunSolvers()
If Not ActiveWorkbook Is ThisWorkbook Then Exit Sub
Dim SourceSheet As Worksheet
Set SourceSheet = ActiveSheet
Call SolverLoop
Call CopyPasteBacktestMape
Call SolverLoopFinal
Call SourceSheet.Activate
MsgBox "Solver's are complete. Proceed to model select worksheet to input forecast adjustments."
End Sub