Hello,

help for,

macro for other macro is hide

kalpesh wrote:

Hello,

help for,

macro for other macro is hide

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?

--
"Tomorrow" is just another word.

On 18/02/2012 1:14 PM, Auric__ wrote:
kalpesh wrote:

Hello,

help for,

macro for other macro is hide

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