Hi F,

Assume the button is from the Forms Toolbar and is named "MyButton"

Should read:

Assume the button is from the Forms Toolbar and is named "Button 1"

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi F,

Assume the button is from the Forms Toolbar and is named "MyButton"
Assume that A1 is the cell to be used to show/hide the buttom
Assume that A1 contains a formula

In the sheet module, paste the following event code:

Private Sub Worksheet_Calculate()
Me.Shapes("Button 1").Visible = _
Range("A1").Value < 10 '<<====== CHANGE
End Sub

As this is worksheet event code, it should be placed in the worksheet
module, not a standard module. Right-click the worksheet tab, select 'View
Code' and paste te above code. Alt-F11 to return to the worksheet.

Change the cell address (A1) and the test value (< 10) to suit your
requirements.


---
Regards,
Norman



"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