Mushy,

You may want to play with Application.OnTime

Sub ScheduleMe()
Application.OnTime Now() + TimeValue("00:00:05"), "RunMe"
End Sub

Sub RunMe()
Beep
ScheduleMe
End Sub


Rob

"mushy_peas " wrote in message
...
Can someone please tell me how:-

1. Auto save a spreadsheet at a particular time or interval

2. Run a macro at a particular time.

Cheers


---
Message posted from http://www.ExcelForum.com/