You need to rephrase that. What do you want? A macro that hides another
macro? A macro that can only be run from another macro? Something else?
It is possible Kalpesh is looking for a code to disable/enable a button
to prevent it from running.
In MSAccess you can use something like
Me.MyButton.Enabled = False
Me.MyButton.visible = False
And or conversely, when Enable = True
But I'm not sure about the Excel equivalent.
HTH
Mick