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

Chris The Rock

Active Member

Joined

Feb 24, 2002

Messages

287

• Nov 5, 2002

• #1

A coworker of mine and me (he's a Board Master here) were talking about some mean things we could do using VBA . . . like pranks, practical jokes and the like. April Fool's kind of stuff.

Any ideas? Has anyone done anything like this?

 

s-o-s

Active Member

Joined

Apr 14, 2002

Messages

384

• Nov 5, 2002

• #2

A good one to play on someone who you regularly send an excel file to (with macros in so that they do not become suspicious by the prompt) is to add in an auto open macro that contains an On Time call macro that pops up a message box warning them that XYZ virus has infected their machine...Please contact the Network Administrator Immediately...Wait until just after they have called the NT admin before alerting them to the prank...Then get out fast...

 

E

elgringo56

Well-known Member

Joined

Apr 15, 2002

Messages

869

• Nov 5, 2002

• #3

I have a customer whose computer I regularly maintain, he is somewhat of a computer dolt, but thinks he is a whiz. On fixing one of his self created problems once, I got into one of his exel files and set it up so that when he selected a certian cells, a msg box would pop up and say something like, "Bill, we at microsoft have spent billions to perfect this software and make it as user friendly as possible, have you ever considered takeing a course or two on how to use it", or, "Bill, it is time that some one told you that you maybe should take this computer back to where you purchased it and try and get your money back, because you just arn't smart enought to use a computer". I have several cell set up within his main spread sheet that should keep him guessing as to what is going on for a long long time.

 

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Nov 6, 2002

• #4

How about having a macro that plays a paricularly loud and long wav file on entry of data into a particular cell - enough to cause panic in many colleagues when the boss is prowling about

 

Sourdust

Well-known Member

Joined

Sep 15, 2002

Messages

769

• Nov 6, 2002

• #5

It's maybe my evil mind but I like this idea . I once set up a user on a Novell network to have to change their password daily and the password had to have at least 40 characters. I pleaded ignorance for about a week before owning up! I like the idea of various messages popping up when a certain cell is selected. Can anybody help me with the code for that , I'm just starting to learn VBA.

Thanks for the laughs.

 

A

applebyd

Active Member

Joined

May 27, 2002

Messages

348

• Nov 6, 2002

• #6

Going back and not particularly Excel related.

I once wrote a routing (c1991) into the MS-DOS Autoexec.Bat file to emulate the Format command without actually doning anything.

Luckily my boss was the author of the appliction being run and saw the funny side.

DaveA

edit:typos
This message was edited by applebyd on 2002-11-06 07:39

 

Bruno_x

Active Member

Joined

Feb 17, 2002

Messages

491

• Nov 6, 2002

• #7

What about this :
Put the following code in an excel file, copy the file to the XLSTART folder...
This could take days to find out...

Private Sub Workbook_Open()
Application.DisplayAlerts = False
Application.Quit
End Sub

 

Corticus

Well-known Member

Joined

Apr 30, 2002

Messages

1,579

• Nov 6, 2002

• #8

Cool topic

I accidently did this to myself once, it took me too long to figure out why nothing was working....

Private Sub Workbook_Open()

Application.EnableEvents = False

End Sub

-Corticus

 

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Nov 6, 2002

• #9

How in the world did you manage to do that to yourself?

 

Chris The Rock

Active Member

Joined

Feb 24, 2002

Messages

287

• Nov 6, 2002

• #10

This is a great thread.

I was thinking of a mean trick...

On workbook open, pop up a userform with a little "quiz" on it. Unless the user gets the questions right, the workbook closes and tells them that they're not allowed to open it.