Solution – Novice Challenge 1: Color My Column

We gave you a good start in this challenge by having you put the code in the Worksheet_SelectionChange subroutine. This subroutine runs each time a new cell is selected. Your solution may be different, but here’s how we solved this challenge: Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next   ‘Take action based…


Solution – Experienced Challenge 2: The Secret Word is FGJAJGSHSBSW

So is this what real spies do all day: write Visual Basic for Applications (VBA) macros that decode five-word messages? Well, to be honest, we’re not at liberty to say; that’s classified information. But as far as we know, yes. So what kind of macros would a secret agent write? Well, again, we’re not a…


Solution – Experienced Challenge 1: That’s a Lot of Jellybeans … Isn’t It?

Well, we said Challenge 1 in the Experienced Division would be an easy one, and guess what: we were right. (And to think our manager bet her manager that would never happen!) Although there were a couple minor missteps here and there, at the time we wrote this no one who had tried Challenge 1…


Day 3

Today is Day 3 of OfficePalooza! The deadline is up for the first two challenges in both the Novice and Experienced divisions. Be sure to check our solutions and see how they compare to yours. Keep in mind that your solutions don’t have to match ours for you to receive your goldfish, they just need…


Day 2

Welcome to Day 2 of OfficePalooza! Just one more day to get those first couple of challenges done. Don’t forget to check out the Home page, where we have links to everything you need. And guess what? Today is Microsoft Office Visio Day! No, there aren’t any challenges this year that use Visio, but you’ll…


Solution – Novice Challenge 5: You Name It

We’ll start out by admitting something to you: we messed up. That probably isn’t a big surprise to anyone. What is a surprise (and a nice one at that) is that we messed up in a way that made things harder on us, but easier on you. (Okay, that really shouldn’t be a surprise either:…


Solution – Novice Challenge 6: How Animated Am I?

For the first five challenges we sort of eased you into all the Visual Basic for Applications (VBA) stuff. This is, after all, the Novice division, so these challenges aren’t supposed to be too hard. But after easing beyond the halfway point, it was time to make things a little more, well, challenging, here in…


The End

OfficePalooza is over, but you can still find all the challenges and solutions from the Home page, as well as links to all sorts of great information about various Microsoft Office products. And be sure to go Solutions for Advanced Business Users of Office, a special feature available for a short time only! Thanks again…


Day 10

Well, this is it. Day 10. The final day of our two-week super-event, OfficePalooza. We’ll continue updating scores until we’ve scored all the entries. We’ll start notifying prize winners soon. Be sure to visit the Home page for links to all the challenges, solutions, and scores.Thank you to everyone who joined us! We had a…


Solution – Novice Challenge 10: Skip It

Did you like the first slide in this challenge? We hope so. The first slide turned out to where Binder Clippy has been hiding throughout OfficePalooza. We wanted to give Binder Clippy a little bigger role throughout this competition, but, well, there were some contract issues…. As a result, Binder Clippy got demoted from emcee…