Saturday, January 21, 2012

VBA Autorun Macros

!... VBA program to schedule your Macro at specific time frame.......!

Sub Autorun_Macro()
Application.OnTime Now + TimeValue("00:00:10"), "Unhide_AllSheets" '''' Macro Automatically Runs when Current time exceeds 10 Seconds
Application.OnTime TimeValue("16:45:20"), "Unhide_AllSheets" '''' Macro Automatically Runs when the Given Time Reached
End Sub

No comments:

Post a Comment

Excel VBA to send email from excel with HTML table in a email body

'' Excel vba script to send email from outlook & email body in HTML table format. ''Write down email body in HTML tags...