Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do not open spreadsheet before a certain time.
What VBA would I write to keep users form opening a file before 10:00 am
everyday? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do not open spreadsheet before a certain time.
This is an extract from the Microsoft Excel XP VBA help file.
Regards, Wayneg '================================================= ==== Wait Method See Also Applies To Example Specifics Pauses a running macro until a specified time. Returns True if the specified time has arrived. Important The Wait method suspends all Microsoft Excel activity and may prevent you from performing other operations on your computer while Wait is in effect. However, background processes such as printing and recalculation continue. expression.Wait(Time) expression Required. An expression that returns an Application object. Time Required Variant. The time at which you want the macro to resume, in Microsoft Excel date format. Example This example pauses a running macro until 6:23 P.M. today. Application.Wait "18:23:00" This example pauses a running macro for approximately 10 seconds. newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 10 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime This example displays a message indicating whether 10 seconds have passed. If Application.Wait(Now + TimeValue("0:00:10")) Then MsgBox "Time expired" End If '================================================= ==== "Qaspec" wrote: What VBA would I write to keep users form opening a file before 10:00 am everyday? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet will not open without Excel Application being open fir | Excel Discussion (Misc queries) | |||
Long time to open spreadsheet (running Excel 2007) | Excel Discussion (Misc queries) | |||
Have date automatically update each time I open the spreadsheet | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |