ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro hide (https://www.excelbanter.com/excel-programming/445397-macro-hide.html)

kalpesh

macro hide
 
Hello,

help for,

macro for other macro is hide

Auric__

macro 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.

Vacuum Sealed

macro hide
 
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




All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com