Sure thing.


- Copy the code below
- Right click on the sheet tab of the sheet containing your data
- Select "View Code"
- This will take you to the VBE (Visual Basic Editor)
- You should see two drop down boxes towards the top of the screen
- The one on the left says "General". Drop down and select
"Worksheet"
- Highlight the code that gets populated and right click and select
Paste to paste in the code below.
- Return to your worksheet


Now anytime the value of Cell A1 is = 1 the worksheet will
recalculate.


Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value = 1 Then
Calculate
End If
End Sub
--------------------


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=567317