Best Excel pranks and jokes
Would you guyz teach me a few pranks and tricks I can do using Excel and VBA? I've got a few ideas like this evil example:
Right click on a sheet's tab and choose (View Code) then paste this code in the white space in front of you:
ZAX
Please Login or Register to view this content.
Last edited by DarthVader68; 03-18-2014 at 08:17 AM.
I'm glad you got it to work :-D
ZAX
Sorry, but I actually dont think that is very funny at all
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
No, not funny at all. As it closes the application, it would also attempt to close all open workbooks prompting the user to save them. If they don't realise what is happening, they could lose data.
Stupid, dangerous and unprofessional.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe this one:
Please Login or Register to view this content.
Another Joke
Cmon TMS and FDibbins, What do you think I'm gonna sell the code or use it randomly? I'll only use it with ppl I know and I'll be watching lol, I'll make sure myself his data is goin to be all safe, I never harmed anyone, I only do this for fun bro ;-)Originally Posted by TMS
Here's another one:
===========================================================================================================
First, Take a screen shot of your desktop as it is and then set this picture as your wallpaper.
Second, If you're using Windows XP: Right click on your desktop and from the (Arrange Icons By) menu unmark (Show Desktop Icons)
If you're using Windows 7: Right click on your desktop and from the (View) menu unmark (Show Desktop Icons)
Third, Right click on the taskbar and choose (Properties), Then mark (Auto-hide the taskbar)
===========================================================================================================
This prank is completely harmless but will make a good joke to your friends :-D
ZAX
No, it won't, it definitely won't.
Just checked your profile. I think your date of birth details probably say everything we need to do.
I'm not 100% sure this works so test it on your own version first, put the code in a new module, save the workbook and run macro_1
Please Login or Register to view this content.
Last edited by ragulduy; 03-17-2014 at 12:53 PM.
Actually guys, None of the previous two suggested pranks worked, but thank you a lot for sharing with me, Rag: Maybe yours didn't work for me cuz I have xl2007?
Thanx guyz
TMS, I expected you to understand without having to do whatever you did, but thx for understanding after all :-)
ZAX
This is the water cooler, anyone on the forum can see what you post - and try it where they want...you would have no control over that, so please consider that for future referenceI'll only use it with ppl I know and I'll be watching lol, I'll make sure myself his data is goin to be all safe, I never harmed anyone, I only do this for fun bro ;-)
Perhaps you could have a bit of fun with:
Running it once reverses all text on the active sheet. Running it a second time restores the text.Please Login or Register to view this content.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
yup the date of birth tells it maybe also the user name? what do you think?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
A lot of code in #10 to do a simple task: reverting text in a sheet
Please Login or Register to view this content.
Last edited by snb; 03-18-2014 at 04:19 AM.
But at least it retains the worksheet: (a) data; and (b) formulae, which means running it a second time restores whatever was already there. Yours tends to destroy both, providing no way of backing out...
PS: You really should learn to declare your variables.
Last edited by macropod; 03-18-2014 at 04:41 PM.
[QUOTE=macropod;3626601]Thx for sharing snb.
I like your one macropod :-)
Thank you very much, I was about to try it when I read your post lol
ZAX
I think this will be safe:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by Leon V (AW); 03-18-2014 at 01:52 PM.
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Omg Izandol, You taught me something new and cool, it's totally cool thank you, It helps with a lot of things :-)I think this will be safe:
Please Login or Register to view this content.
Alpha, Your one is really disturbing, I like it :-D
Leon, Yours shows an error msg:
-----------------------------------
Compile error:
User-defined property not defined
-----------------------------------
At:
Thank you all for sharing, I got something I made in my free time, have a look:Please Login or Register to view this content.
P.s: The heart will appear in red cuz it's a wrong syntax to VBAPlease Login or Register to view this content.
ZAX
Last edited by DarthVader68; 03-18-2014 at 11:58 PM.
your extensibility is not on.Leon, Yours shows an error msg:
-----------------------------------
Compile error:
User-defined property not defined
-----------------------------------
At:
Please Login or Register to view this content.
try
this in the workbook moduleand this in the sheet modulePlease Login or Register to view this content.Please Login or Register to view this content.
Last edited by Leon V (AW); 03-19-2014 at 07:35 AM.
Hi Leon,
I did a few to changes to the first code and added the second msgbox text to make it work, and now it does:
P.S: The second code didn't work neitherPlease Login or Register to view this content.
I like your code, It's good :-)
ZAX
Really? do you have a PERSONAL.XLSB file? I supose you could have it save a copy of itself as an addin and have it instal itself to get arround that, everyone I have used it on in the past has had VBE set and a personal.xlsb file.
Yeah I have used it before
Please Login or Register to view this content.
not my code. tell it toThis GuyPlease Login or Register to view this content.
Do not use code you do not understand.
Do not copy code without reference to it's author.
PLEASE Do not make accusations with no evidence to back it up (I understand it fine thanks)
PLEASE do not issue commands to someone you have no durestiction over. (citation is not required as I am not selling the code)
I think he's right cuz you're the one taking the credit, besides, it only takes a few seconds to say "This guy had a code like:" so just take his advice, It's not nice to take credit for other's codes even if not selling.
And no I don't have a PERSONAL.XLSB
ZAX
I think this thread has gone on enough now.
Im sure many companies would take exception to their employees using code like this on company computors (about which other members have also complained) - some of the code could actually cause harm or cause people to lose data. NOT the kind of reputation this forum would care for. (not to mention feathers that are being ruffled)
With that said, I am closing this thread now
Interesting that he has chosen the name of a character from a movie that is more than twice as old as he is
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks