Hi
Will try to give you as much info as I can. I am assuming you are using Excel 2007.
1. Ensure Developer TAB is on the Ribbon, if Not. Do the following.
2. Click The Office Button in the top left hand corner.
3. Click Excel Options Bottom Right
4. Tick "Show Developer TAB on Ribbon
5. Click OK
Once Developer TAB is evident select it. Then do the following.
1. Copy The Code below to the clipboard.
2. Select Visual basic on the left of the ribbon.
3. Select Sheet from left hand pane "prob. Sheet1(Sheet1)"
4. From Left hand drop down in the right hand pane select "Work Sheet"
5. From Right hand Drop down in right pane select change
6. Insert The code you copied earlier here where the cursor is positioned.
Code:
Application.ScreenUpdating = False
Static counter
On Error Resume Next
If Range("g4").Value < 0.416666667 And counter < 1 Then 'Action Criteria
Call Macro1 'Your Macro Name
End If
counter = 1 ' Counter Increased to 1 to stop the macro being called each time the Sheet changes when the timer is less than 10 Mins
If Range("g4").Value >= 0.416666667 Then counter = 0 ' Set Counter to 0 if Time Greater Than 10 mins
Back to your sheeet now, when the counter gets below 10 mins your macro will be called once when you change a value in the spread sheet. If the counter is greater than 10 mins the macro will not be called.
regards
Kev