This is driving me nuts; I have reviewed it 25-30 times I have
Calculation-Automatic on;

In Sheet1 cell A1 - I enter 10; [Button 1] shows
I enter 0 in A1 [Button 1] still shows

In Sheet1 Module I have in:
Object box: Worksheet
Procedure Box: Calculate
In Code window:

Private Sub Worksheet_Calculate()
With Range("A1")
If IsNumeric(.Value) Then _
Me.Shapes("Button 1").Visible = .Value 0
End With
End Sub

From the Forms Toolbar I created a Command-button
And assigned a macro to (in a standard module) of the WB:

Sub Foo()
MsgBox "Testing"
End Sub

Confused on a Friday night....
Any help appreciated..
Jim


"JE McGimpsey" wrote in message
:

If you put the macro in your worksheet code module, it updates
automatically every time the worksheet is calculated, hiding the button
is A1<=0, displaying it if A10..

In article <Git4g.16365$fG3.15781@dukeread09, "JimMay"
wrote:


I'm missing something here. Once I create button1 on the screen which
is to be visible once cell A1 updates to greater than 0 - How do I hide
it?