Hi does anyone know anygood practicle jokes for excel... i.e. having an auto open macro that looks like the user has been infected and their pc is automatically typing each letter instead of the example i have below which just does the whole sentence at once... and any other good practicle jokes to play on the "staff" we have here at work?
I know this is sloppy just done with the recorder for most of it, could have some loops for the countdown sequence but I have a feeling that this wheel has already been invented.
I know this is sloppy just done with the recorder for most of it, could have some loops for the countdown sequence but I have a feeling that this wheel has already been invented.
Code:
Sub auto_open()
Application.OnTime Now + TimeValue("00:00:5"), "DisplayMessage"
End Sub
Sub DisplayMessage()
Range("A1").Select
ActiveCell.FormulaR1C1 = "Hey Matey"
Application.Wait (Now + TimeValue("0:00:2"))
Range("A2").Select
ActiveCell.FormulaR1C1 = "Bet you didn't know that you could do this huh"
Application.Wait (Now + TimeValue("0:00:3"))
Range("A3").Select
ActiveCell.FormulaR1C1 = "Just taking over you computer"
Application.Wait (Now + TimeValue("0:00:2"))
Range("A4").Select
ActiveCell.FormulaR1C1 = "DON'T STESS"
Range("A4").Select
Selection.Font.Bold = True
Application.Wait (Now + TimeValue("0:00:2"))
Range("A5").Select
ActiveCell.FormulaR1C1 = "it is all good just having a little play"
Application.Wait (Now + TimeValue("0:00:2"))
Range("A6").Select
ActiveCell.FormulaR1C1 = "and now for the count down"
Application.Wait (Now + TimeValue("0:00:2"))
Range("A7").Select
ActiveCell.FormulaR1C1 = "5"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A8").Select
ActiveCell.FormulaR1C1 = "4"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A9").Select
ActiveCell.FormulaR1C1 = "3"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A10").Select
ActiveCell.FormulaR1C1 = "2"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A11").Select
ActiveCell.FormulaR1C1 = "no wait lets do it like this"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A12").Select
ActiveCell.FormulaR1C1 = "5"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A12").Select
ActiveCell.FormulaR1C1 = "4"
Range("A12").Select
Application.Wait (Now + TimeValue("0:00:1"))
ActiveCell.FormulaR1C1 = "3"
Range("A12").Select
Application.Wait (Now + TimeValue("0:00:1"))
ActiveCell.FormulaR1C1 = "2"
Application.Wait (Now + TimeValue("0:00:1"))
Range("A12").Select
ActiveCell.FormulaR1C1 = "1"
Application.Wait (Now + TimeValue("0:00:1"))
ActiveCell.FormulaR1C1 = "Termination sequence activated"
Selection.Font.Bold = True
Application.Wait (Now + TimeValue("0:00:3"))
Application.DisplayAlerts = False
Application.Quit
Application.DisplayAlerts = True
End Sub