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

[dcanham]

well...this is an old thread....but good. I think I need to bump it again!

 

[jan001]

This is similar to at least one I saw earlier in this thread but different enough to warrant a mention, I think.

My first computer mentor, back in the mid-1980s, had an "evil genius" streak. He was given the task one day of devising an automated training program to re-train new employees who were having trouble with even the most basic operation of the computer system.

He didn't use a spreadsheet, but it could have easily been done with Excel, had it been around at that time.

I forget what he wrote it in, but the upshot was that the user had to type in their name as part of the login, and the program would call them by their first name when they answered a question correctly. "Very good, Betty, let's try another one."

He also rigged it so that, when they got one wrong, the first name was replaced with "dumba$$" (edited for the board), so that an error got you, "No, dumba$$, try again."

He only left it in place a few days before better judgement prevailed, but oh, the possibilities.

 

[Oorang]

This would be really mean to do... Put funny to ponder

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
    On Error GoTo Err_Hnd
    Dim ws As Excel.Worksheet
    For Each ws In ThisWorkbook.Worksheets
        ws.UsedRange.Replace "John Doe", "Lunk-Head", xlPart, xlByRows, False
    Next ws
    Exit Sub
Err_Hnd:
End Sub

 

[SydneyGeek]

Just saw one...

A guy amused himself by taking a screenshot of the user's desktop, using it as the wallpaper, Autohiding all the icons and Startbar, and oberving as they clicked away on the image.

Denis

 

[agihcam]

simple one.
when a surname was type everywhere in a cell, the first letter will become lowercase.

 

[Zack Barresse]

Just saw one...

A guy amused himself by taking a screenshot of the user's desktop, using it as the wallpaper, Autohiding all the icons and Startbar, and oberving as they clicked away on the image.

Denis

ROFL! That's great.

 

[agihcam]

this trick is hard to detect by an ordinary user.
when a user leave his/her machine, set-up a Scheduled Task to open as many excel file you want the same time ( I've set it up daily ).

 

[Greg Truby]

Just saw one...

A guy amused himself by taking a screenshot of the user's desktop, using it as the wallpaper, Autohiding all the icons and Startbar, and oberving as they clicked away on the image.

Denis

Isn't that what Pook described roughly four years ago on this same thread?

 

[Oorang]

Yep and it was classic back then too. I can remember doing that to people clear back in like '98 Some things just never get old.

 

[cheryl.bower]

What about placing a default . in cell IV65536? When they start printing with out setting a print area . . . well, you get the idea. Enviro nuts wouldn't like it too much, but it would drive the user crazy. Hopefully, they would cancel the print job before the end. Some people would never figure that out. And it wouldn't destroy the files on the computer like a virus can. Just a little harmless . ...