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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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" wrote in message
...

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

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


any help would be great

thanks alan bourne


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

does anybody have a clue about thi

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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 **
"alan_bourne" wrote in message
...

does anybody have a clue about this


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/