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/