How to set Macro1 invisible to the user?

[navic]

I have an ActiveX button on the Index worksheet. By clicking on this button i want to call two VBA macros

In Module1 exists
Macro1 = Import multiple specific sheets from all files in folder
Macro2 = List all sheets on Helper sheet in active wokrbook

However, I do not want the user to see these two macros, in the 'Macros' window on the 'Developer' menu tab.
If I set "Private" then the button does not work.

How to run two "Private" VBA macros with one button if the macros are located in Module1. Is that possible?
This is the VBA macro located in the sheet module (Index)

Private Sub CommandButton1_Click()
    ActiveSheet.CommandButton1.BackColor = &HFF&
    Call Macro1
    Call Macro2
End Sub

can somebody help?

 

[Fluff]

You can call them like

Application.Run "Module1.macro1"

 

[navic]

You can call them like

This work
Thank you Fluff

 

[Fluff]

You're welcome & thanks for the feedback