timed macro

  • Thread starter Thread starter alan_bourne
  • Start date Start date
A

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
 
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 **
 
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 **
 
Back
Top