Change the Sheet in which a Macro os run from

[DownUnderFar]

I have a number of Macros, and some of them consist of multiple macros that use the Call Command. For example:

Sub 01()

Call 02
Call 03

End Sub

I created these all to be run on the current sheet, named "Workspace". I'd like to place buttons on a different sheet that I've named "Buttons." Is there a simple one-line code that I can insert into either the parent macro or each individual macro to instruct it to run off of sheet "Workspace?"

 

[Domenic]

You can have the calling procedure pass the desired worksheet to the procedure being called...

Sub main_macro()

    Call macro1(Worksheets("Workspace"))
    
    Call macro2(Worksheets("Workspace"))
    
End Sub


Sub macro1(ByVal ws As Worksheet)

    Debug.Print ws.Name
    
End Sub

Sub macro2(ByVal ws As Worksheet)

    Debug.Print ws.Name
    
End Sub

By the way, the Call keyword isn't actually needed when calling a macro. You can simply call a macro as follows...

    macro1 Worksheets("Workspace")

Hope this helps!