Good Excel Practical Jokes, Pranks, Mean Tricks, etc.

[Stu Dapples]

Wow, I've managed to waste nearly a whole day reading this little gem! You certainly can be some evil folk, hope I never get on the wrong side of you!

A very simple (non VBA I'm afraid)one: I did this to my boss 3 years ago..... And it is still working!!

Get hold of Lotus Notes or any e-mail prog. Set the recieve mail settings play sound, I picked the annoying TA DA from Windows but you can use any.... My Boss is not the most tech savvie and can't figure out how to stop it....

Every time he is in the office and gets a mail, the TA DA is accompanied by a VERY frustrated tut!! My colleague and I have literally cried over the years!!

 

[Peter_SSs]

(and i've entered it under the tab and view code area)

You would need to put it in the ThisWorkbook module.

 

[Woodster]

Shame on us! I did this one to myself....select two or more tabs and save file. When the next person opens it, lots of functionality won't work!

 

[Bruno_x]

Private Sub Workbook_Open()
    Application.DisplayAlerts = False
    Randomize
    annoying_level = 100
    annoying_number = 100 * Rnd
    If annoying_number < annoying_level Then
        Application.Quit
    End If
End Sub

I've entered this into the VBA; but when i open it to test it (since i've put it to 100 it should close everytime) it doesnt seem to work

Am i doing something wrong or missing something?

-----------------
Using Excel 2003

It's nice to see that a few lines of VBA code are still tested, more then 8 years after I've posted the message...

 

[zizzerboy]

You can do it with an API call (ChangeDisplaySettingsEx). The function documentation is here: http://msdn.microsoft.com/en-us/library/ms533235(VS.85).aspx

And the how-to is here: http://msdn.microsoft.com/en-us/library/aa927391.aspx

This is an old post, but has anyone gotten rotating the screen to work in vba? I'm not very good with API calls... but I would really like to pull this one on my colleague

 

[Michael M]

Try
CTRL + Alt + down arrow
I don't think it works in 7 though.

 

[FIFARay007]

Try
CTRL + Alt + down arrow
I don't think it works in 7 though.

DAMMIT!!! Where were you 5 days ago???

 

[spcalan]

Try
CTRL + Alt + down arrow
I don't think it works in 7 though.

yep, don't work in 7. what a shame.
I guess I will have to stick with the usual hidden macros.. ha.

 

[schielrn]

Works in Windows 7 for me? Didn't work in XP for me when I had dual screen, but now it is real finicky with my dual screens.

 

[TinaP]

Try
CTRL + Alt + down arrow
I don't think it works in 7 though.

I think it depends on the video card. We have some XP computers that it works on, others where it fails.