OnTime / TimeValue

[Myriam]

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,

[mudraker]

Myriam

I usually use the code in a normal module sheet, But I see no reason why it could not be placed in a sheet module.

The biggest problem you would have is where is the macro your ontime procedure is located. eg sheet module, workbook module, normal module