I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion of
a selected period? I am using Windows XP Home with Office 07.

this should hide the sheet after 2 seconds after A1 is changed


Private Sub Worksheet_Change(ByVal Target As Range)
Const WSrange As String = "A1"
Dim i As Long
If Not Intersect(Target, Me.Range(WSrange)) Is Nothing Then
Application.Wait (Now + TimeValue("0:00:02"))
ActiveSheet.Visible = xlHidden
End If

End Sub

--


Gary


"Charlie Betz" wrote in message
...
I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion of
a selected period? I am using Windows XP Home with Office 07.

don't need the dim statement, put it there by mistake


Private Sub Worksheet_Change(ByVal Target As Range)
Const WSrange As String = "A1"
If Not Intersect(Target, Me.Range(WSrange)) Is Nothing Then
Application.Wait (Now + TimeValue("0:00:02"))
ActiveSheet.Visible = xlHidden
End If

End Sub

--


Gary


"Charlie Betz" wrote in message
...
I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion of
a selected period? I am using Windows XP Home with Office 07.

This may assist:
http://www.mrexcel.com/archive/VBA/7422a.html

Corey....



"Charlie Betz" wrote in message
...
I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion
of
a selected period? I am using Windows XP Home with Office 07.