View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Macro-Button make tu hide?

You probably can with the visible property. And do it in a macro.

But a lot depends on what kind of button it is:
toolbar
forms toolbox
control toolbox
text box
shape
or built from a macro.

Do you know about event macros?
There is a way to capture the cell change...

Tell us more...
Where does the button come from (how did you build it)
What changes the cell value (formula, manual entry, etc).
What is it you really want to do...
--
steveB

Remove "AYN" from email to respond
"frenic" wrote in
message ...

Hi,

cann I the macro-button make to hide?
Optional - dependent from the cell value.

Please, don't say NO!

Thenks
F.Vergan


--
frenic
------------------------------------------------------------------------
frenic's Profile:
http://www.excelforum.com/member.php...o&userid=25297
View this thread: http://www.excelforum.com/showthread...hreadid=387878