This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Want to wind up your neighbour? Try this annoying Excel VBA code! Part one of a two-part series of blogs
If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it! Amusing(?) Excel macros to send to your colleagues (this blog) Creating the Rogue Excel Workbook

Want to wind up your neighbour? Try this annoying Excel VBA code!

Part one of a two-part series of blogs

If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!

Amusing(?) Excel macros to send to your colleagues (this blog)
Creating the Rogue Excel Workbook

Posted by Andy Brown on 18 September 2024

Amusing(?) Excel macros to send to your colleagues

If you're bored one day, you could always create a workbook to annoy your workmates! Initially this would look fairly harmless:

All of the interesting figures are clearly on the other worksheet ...

It's what happens then that would be a tad irritating. When you clicked on the other worksheet to see the interesting figures, you'd see a message like this:

When you choose OK, you'll be left on the original worksheet.

Frustrated, you'll try closing the file down, only to see this message:

When you click OK, the workbook will remain what it was before - open.

Finally, you might click on the button to display help instructions. Firstly you'd get a message asking you to turn your speaker on:

If you choose No, you'd get a message telling you not to waste time.

If you choose Yes above, your computer would speak the following message:

"Welcome to the dark side!"

So how does all this work? Click on the link below to find out, but first a disclaimer:

This is only meant for fun, and any workbook that you create is your own personal responsibility!

One other note: if your intended victim should happen not to trust you, they will (sensibly) not enable any macros in your workbook, and none of the above will work.