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

[Hermanito]

Yep, username specific "alterations" are great

I once added a button for one specific colleague only, labeled 'DON'T CLICK THIS BUTTON!!', with code behind that shuts down the PC without asking. Guess what happened?

 

[bamblack]

I put in a little code so whenever they open the spreadsheet it displays a "Loading" progress bar that I created with a little userform, then after about 10 seconds it quits Excel and opens up Word

The button labelled "DON'T CLICK" is a classic.

 

[Engineer Joe]

One of my favorites is to walk up to a coworker when they are working on a spreadsheet and I say,"oh, looks like you have an error in that formula." They always fall for it and say,"what formula?" I bring my finger up as if to point at the screen but then at the last instant I gently poke them in the eye. This one is even funnier if they owe you money because then they have a mixed sense of hate and obligation to you.

 

[KWilley]

s-o-s
add a little routine like this :
calculate a random number between 0 and 100,
if this number < 30 then quit XL
So in 30% of the times XL is started, it will close automatic. The user will find this very annoying :wink: :wink:




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

</PRE>
_________________
<TABLE border=1><TBODY><TR><TH>Bruno </TH></TR></TBODY></TABLE>

[SIZE=-1][ This Message was edited by: Bruno on 2002-11-08 08:29 ][/SIZE]

I just saw this thread and was thinking (a dangerous thing)... I did one like this one time, but I started at 5 with the annoying level. It shut down about 5 percent of the time. However, each time it shut down, it added 5 to the annoying_level. It took a while, but people got panicked over time.

 

[kfong0128]

I started learning Excel VBA since six months ago. Now only I discover that VBA could be so much fun.
Of course, these have to be put into right and legal application, without "evil-intention".
Thanks for all.
I really start enjoying VBA ...........Thanks..........to...........alllllllllll....

 

[kfong0128]

Hi, thanks for the "fun-part" of VBA. Otherwise, writing VBA code could be boring.

Just curious, what happen if the PC is without any CD drive ?

Thanks.

 

[Jon von der Heyden]

Well this thread already has 40 pages so I'm not about to read the entire thing; so apologies if this has been mentioned already.

I once had a colleague that would brag about his Excel abilities endlessly. His challenges were pathetic, regularly popping over my desk to ask if I know the shortcut to some command, and then gloat when I didn't... He wasn't so advanced though, having never written a macro in his life.

One day he popped off and forgot to lock his machine. So I created a list of profanities (e.g. "you #&%^") and then overwrote several of the regularly used shortcuts (like Ctrl+C) to randomly Speak an item from the list of profanities (using OnKey and Speech).

For anyone that would like to replicate this, some of the words are not spoken properly (as MS didn't include profanities in their speech dictionary), so remember to spell them phonetically.

 

[Domski]

Well this thread already has 40 pages so I'm not about to read the entire thing;

It's not like you've got anything better to do

Dom

 

[Jon von der Heyden]

It's not like you've got anything better to do

Dom

:middlefinger:

Edit: ^ darn emoticons aren't working again

 

[Joe4]

One day he popped off and forgot to lock his machine. So I created a list of profanities (e.g. "you #&%^") and then overwrote several of the regularly used shortcuts (like Ctrl+C) to randomly Speak an item from the list of profanities (using OnKey and Speech).

That's deviosuly brilliant!

Along those lines, a very easyt thing to do is to have fun with the AutoCorrect feature. You can replace any word with any other word of your choosing. The possibilities are endless!!!
(This may have also been mentioned earlier, but I am not about to read through 40 pages either!).