timed macro

[alan_bourne]

is it possible to create a macro that gots to a page for a set amount o
time for example

cell "a1" in sheet "welcome" for 5 seconds then return to the pag
"sales"


any help would be great

thanks alan bourn

 

[Paul B]

Alan, give this a try

Sub wait()
Sheets("welcome").Select
Range("A1").Select
Application.wait Now + TimeValue("00:00:05")
Sheets("sales").Select
Range("A1").Select
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[alan_bourne]

does anybody have a clue about thi

 

[Paul B]

Did you try the code I posted?

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **