Posted to microsoft.public.excel.programming

Myriam

external usenet poster

Posts: 97

OnTime / TimeValue

I am trying to close a sheet1 and open sheet2 after 15 seconds.

How can I use the OnTime/TimeValue to do this?

Where should I place the code? In Sheet1 or Wkbk?
I appreciate any light you can give me.
Thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find %ontime & SUMIF ontime ie: find matching sets within Range...	Chris T-M	Excel Worksheet Functions	3	October 10th 08 08:14 PM
timevalue function	busterpace	Excel Worksheet Functions	2	October 8th 06 03:39 AM
iserror(Timevalue())	Basil	Excel Programming	5	May 5th 05 01:26 PM
DATEVALUE and TIMEVALUE	Carl Hartness	Excel Programming	1	May 26th 04 05:14 PM
Need Help with Code - TimeValue	Donnie Stone	Excel Programming	1	October 4th 03 04:14 PM

All times are GMT +1. The time now is 11:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us